Forum Discussion
Help splitting table rows out to multiple rows in new table
I need to split individual rows of an existing table out to new rows in a new table (for export)and don;t know how to even begin this!? I'm happy to do the research if someone is kind enough to p...
This can be done with Power Query. In the attached file you can add data to the blue dynamic tables. Then you can click in any cell of the green table and right-click with the mouse and select refresh to update the green result table.
The data layout in the screenshot and in the attached file is for illustration. You can place the green result table to the right of the blue tables or in another worksheet. The blue tables can be arranged horizontally as well.
