How to convert groups of rows into the right layout for Power BI or Pivot Tables using Power Query
Integer divide (also known as floor division) is a mathematical operation that divides two integers and returns the quotient rounded down to the nearest whole number. It's often used in programming languages to return an integer result from a division operation, unlike regular division which can return a decimal value.
Using Power Query to convert groups of rows into the right layout for Power BI is one way of transforming data for use in Power BI dashboards or reports. Using Power Query allows users to transform data quickly and easily by allowing them to group, filter, pivot and unpivot columns; split text values; add custom columns with formulas; merge queries together; and much more. This makes it easy for users who don't have extensive coding knowledge or experience using SQL or other query languages to manipulate their data according to their needs.
Option so we'll click the advanced. Options. And here you can choose split into and then select rows
How to Merge Rows In Power Query
Use an aggregate function to group by one or more columns
How to combine rows in Power Query