You can see table inbound with data in several rows per each key (key 10 has 2 rows)
Is there a chance to manipulate outbound or inbound so I have only one row per key and the columns a and b (now in separate rows) in a1, b1, a2, b2, β¦
In original you can find the data as they are in inbound.
In result you can see the result
(data have to be transformed from horizontal to vertical, multiple rows to multiple columns)
I used colours in the screenshot to show data source and destination.
You need to add a column which identifies the instance of the row, eg a row count by RowID (eg 1, 2). Then you can Pivot on this column. To add the said column, Group Loop Start over key β Math (Rowindex+1) β Loop End.