New Table with Column Names from other table data

[BBurnett]

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 solution]

Hello @BBurnett ,

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.

Thank You,

Washivale

[JosefPrakljacic · Accepted solution]

Hey @BBurnett ,

just do that stuff in the ScreenGif. Be careful regarding the aggregation type. You have 2 dates for Y and need to decide what to do with it.

Explanation

If this post was helpful may I ask you to mark it as solution and give it some kudos?

Have a nice day!

BR,
Josef

[Washivale · Accepted solution]

Hello @BBurnett ,

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.

Thank You,

Washivale