Creating New Columns from Rows

[hjcho928]

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

[flying008 · Accepted solution]

Hi, @hjcho928 

FYI.