Moving Data from Multiple Rows into One Row Based on Unique ID

[michaelhodges1]

I have data that looks like this

ID|First|Last|Purchase|Date

333|John|Doe|Truck|January

444|Jane|Smith|Car|January

333|John|Doe|Car|February

333|John|Doe|Tractor|March

444|Jane|Smith|Truck|April

I would like for all of the information about John Doe and Jane Smith to be in 1 row but in all separate columns.

Thanks!

[v-chuncz-msft · Accepted solution]

@michaelhodges1,

You just need to select Pivot Column in Query Editor or use a Matrix visual.

[michaelhodges1]

I have data that looks like this

ID|First|Last|Purchase|Date

333|John|Doe|Truck|January

333|John|Doe|Car|February

333|John|Doe|Tractor|March

I would like for all of the information about John Doe to be in 1 row but in all separate columns.

Thanks!