Merge Rows But Move Unique Values To New Column

[ThePhoenix]

Hi Wonderful People,

I have a conudrum and hoping someone can shed some light to help.

I have a file with around 20k rows of account data however for some reason the rows are duplicated because of package service and it looks like this:

Account Name --------- Join Date ----------- Other Columns ------------ Package
Account 1 -------------- 1/1/19 -------------- Data ----------------------- Main Package
Account 1 -------------- 1/1/19 -------------- Data ----------------------- Bolt On
Account 1 -------------- 1/1/19 -------------- Data ----------------------- Add on
Account 2 -------------- 1/1/18 -------------- Data ----------------------- Main Package
Account 3 -------------- 1/1/17 -------------- Data ----------------------- Main Package
Account 3 -------------- 1/1/17 -------------- Data ----------------------- Add on
Account 4 -------------- 1/1/19 -------------- Data ----------------------- Main Package

Is it possible in Excel using some type of INDEX or something where I can create a new tab where there is just one row for each account name then it looks up that column for the Package column and adds the first value then if there are additional matches it puts it in the next column?

So it would look like this:
Account Name --------- Join Date ----------- Other Columns ------------ Main Package ----- Extra Item --- Extra Item
Account 1 -------------- 1/1/19 -------------- Data ----------------------- Main Package ----- Bolt On ------- Add On
Account 2 -------------- 1/1/18 -------------- Data ----------------------- Main Package
Account 3 -------------- 1/1/17 -------------- Data ----------------------- Main Package ----- Add On
Account 4 -------------- 1/1/19 -------------- Data ----------------------- Main Package

Is this doable? As you can see I dont need them to organize the columns based on package type I just need this column to move into the row so I only have 1 row for each account.

Thanks for any help you can provide!

[JeteMc]

This proposal employs a helper column (E) which may be moved and/or hidden for aesthetic purposes and which is populated using: =COUNTIFS(A$2:A2,A2)
The Name:Main columns (light green) are populated using: =IFERROR(INDEX(A$2:A$8,AGGREGATE(15,6,(ROW($A$2:$A$8)-ROW($A$1))/($E$2:$E$8=1),ROWS($A$1:$A1))),"")
The Extra columns (darker green) are populated using: =IFERROR(INDEX($D$2:$D$8,AGGREGATE(15,6,(ROW($A$2:$A$8)-ROW($A$1))/($A$2:$A$8=$F2)/($E$2:$E$8=COLUMNS($A$1:B$1)),1)),"")
You will usually get faster responses if you utilize the instructions in the banner at the top of the page.
Let us know if you have any questions.