Add Split Rows into n groups to Power Query
In Power Query you can easily split a column into multiple columns. Recently I have had several examples where I needed to split a data set into equal groups of 4 (not bins or frequency). I had to count the total number of rows in the data set. Then insert a blank row evenly between each quarter of the data set. Yes there's probably VBA to do it, but I'd rather have it as part of a PQ solution.
1
vote
Richard
shared this idea
1 comment
-
Kenneth Barber commented
That sounds like Power Query's Table.Partition function. I don't think that there is any button that will do this for you, so you will need to write the code for it manually.
https://docs.microsoft.com/en-us/powerquery-m/table-partition