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|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!

2 Replies

  • 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!