New Table with Column Names from other table data

Question

I am trying to create a new table that has a single row based on primary ID and column names from values in the data but I just can't get it to do it. There is no need for an calculations as value field is a string. Any help would be appreciated.

From this:

ID	Date	Value
Id 1	1/01/2019	X
Id 1	5/01/2019	Y
Id 1	7/01/2019	Y
Id 2	2/01/2019	X
Id 1	10/01/2019	Z

to this:

ID	X	Y	Z
Id1	1/01/2019	7/01/2019	10/01/2019
Id2	2/10/2019

washivale · Accepted Answer

Hello&nbsp;BBurnett ,&nbsp;You can achieve this with Pivot Function of Power Query, Go to Edit Query - Transform - Select value column - Pivot - then select Date from Drop Down and apply aggregation (if any) like Max date for the ID.&nbsp;Thank You,Washivale

Forum Discussion

New Table with Column Names from other table data

2 Replies

Related content

Changing lakehouse table column names

Column data = table name

Dynamic Column Name

Delta Table Column name length

Schema Name for Tables