Hopefully this can be done without a Macro?
Using Power Query, I get a result with 3 columns, and varying number of rows.
This is then going to be linked to a PowerPoint document, but the number of rows is too many to fit and be readable on a single slide. We are currently manually moving a group of cells around to make it look better before pasting onto the slide. All other slides are linked back to the workbook so just needs a refresh..
is there a way to split by say 30 rows into as many columns as need?
Sample file enclosed.
thanks
Bookmarks