Transpose Data from Columns to Rows after each unique data point

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

Did I post this in the wrong area or should I provide a better explanation?

Button on sheet2 and output on sheet after.

Hi,

I don't believe that this needs to be done using macros (although it wouldn't be a short formula using Excel functions ), but seeing as this is in the VBA section of the forum, here is a VBA solution for you...

I hope this helps

Hi again,

Here is a non-VBA solution

You guys are amazing! That worked perfectly, thanks!!!

You're welcome!

Please don't forget to mark this thread as solved, and please click on the * next to any post(s) that have been helpful to you, just to say thanks to the poster(s) and add to their reputation