Hello All!

I need help manipulating some data.

I have data lined up in columns with column "A" being the account number and column "B" is the program the account is in. The account can be in multiple programs (up to around 10) and it could be in as few as 1 program.

example:
Account # Model
12345 Balanced
12345 Growth
12345 Income
84567 Bond
84567 Stock
21567 Income

I need the data to line up in one single row for each account number with each program for the account lined up with the account number.

example
Account # Program 1 Program 2 Program 3 Program 4 Program 5 Program 6
12345 Balanced Growth Income
84567 Bond Stock
21567 Income

Thanks for the help!

LukeHelp.xlsx