Hello Community,
Based on my existing data like below, I'm looking for a way to create and populate new columns based on Account Number matching. Would greatly appreciate everyone's guidance to get this working. Thank you!
Current Data:
| Account Number | Name |
| 1234 | John |
| 1234 | Lucy |
| 5678 | Heather |
| 5678 | Sean |
| 9101 | Richard |
Desired Output:
| Account Number | Name 1 | Name 2 |
| 1234 | John | Lucy |
| 5678 | Heather | Sean |
| 9101 | Richard | |
