Forum Discussion

michaelhodges1's avatar
michaelhodges1
New Member
8 years ago
Solved

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

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|Truc...
General Comment
Need Help
Tutorial Requests
  • v-chuncz-msft's avatar
    v-chuncz-msft
    8 years ago

    michaelhodges1,

     

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

michaelhodges1's avatar
michaelhodges1
New Member
8 years ago

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!