Collapsing rows into a single row with additional columns

[saddas]

Hi, I would like to collapse values from my rows into a single row with additional columns.
Starting point:

RowID	Col1	Col2
Row0	Value 1	Value 2
Row1	Value 3	Value 4

Expected result:

RowID	Col1	Col2	Col3	Col4
Row0	Value 1	Value 2	Value 3	Value 4

Thanks!

[HansS]

Hi @saddas

Try something likes this.

gr. Hans

[saddas]

@HansS : Thanks, this works!
I also got it to work with Unpivot/ Pivot.