I am trying to find the best way to split the output from Power Query, into multiple, fixed number of rows, columns.
My query output is 4 fields wide and can be 100+ rows long. I would like the output be 48 rows in each multi-field column.
|Field1 Field2 Field3 Field4 | Field1 Field2 Field3 Field4 | Field1 Field2 Field3 Field4 |
|48 ROWS |48 ROWS |Whatever is left...
Currently I have 4 separate queries on each worksheet. For a total of 24 queries. Each query is a copy with a 'keep number of rows' filter on it. I would really like to do this with one query or even one per worksheet.
(Sorry I can't seem to get the post to look good)
My query output is 4 fields wide and can be 100+ rows long. I would like the output be 48 rows in each multi-field column.
|Field1 Field2 Field3 Field4 | Field1 Field2 Field3 Field4 | Field1 Field2 Field3 Field4 |
|48 ROWS |48 ROWS |Whatever is left...
Currently I have 4 separate queries on each worksheet. For a total of 24 queries. Each query is a copy with a 'keep number of rows' filter on it. I would really like to do this with one query or even one per worksheet.
(Sorry I can't seem to get the post to look good)
Last edited:
