JackDanIce
Well-known Member
- Joined
- Feb 3, 2010
- Messages
- 9,922
- Office Version
- 365
- Platform
- Windows
Hi,
In PQ, I have created a table size 2 columns by 15 rows and I need to split this into separate rows and output to a single sheet, starting B4, then B39, B74, every 35 rows.
As a starting point, I've created a query with connection to B4 as:
Before I manually split the table row by row, then connect output to a sheet, is there any way to automate this or use a loop? The actions seems simple enough to automate...
If I still have to manually make the connections to each table, is there a way to loop over the table to generate new tables row by row?
TIA,
Jack
In PQ, I have created a table size 2 columns by 15 rows and I need to split this into separate rows and output to a single sheet, starting B4, then B39, B74, every 35 rows.
As a starting point, I've created a query with connection to B4 as:
Power Query:
= Table.SelectRows(data_output_custom_datatype, each [PTJ] = "PTJ 1")Before I manually split the table row by row, then connect output to a sheet, is there any way to automate this or use a loop? The actions seems simple enough to automate...
If I still have to manually make the connections to each table, is there a way to loop over the table to generate new tables row by row?
TIA,
Jack
