Forum Discussion
michaelhodges1
8 years agoNew Member
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
- michaelhodges1New Member
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!
- v-chuncz-msft
Community Support