Find duplicates in one column, and combine all rows into one with new columns

Hi BJXcel,

A very similar question was asked a few days ago with two good answers. See it at:
https://www.excelforum.com/excel-gen...t=#post5477786
If the above doesn't help, keep asking and supply a sample workbook to improve your chances of getting a good/better ansewr.

Hi,

We need a sample of your data to see where things are. Which columns need sweeping and which need staying. Without a good sample we just can't give you a good answer. Read the yellow header on the site to learn how to attach a sample workbook.

So, to be clear, in my example I want the account number to be the unique item/column that the consolidation is being based on. And in the end, I want only one row associated with any one account number. If all the rows of information get thrown into one consolidated row, at least I can go back through and make column headers that make the new data clear if data repeats itself. The reason I'm wanting to do all of this, is because I want to do a mail merge, and that's not going to work having rows of repeat data.

Additionally, with the mail merge, I may have to even put two different accounts for the same person on the same line. I'm hoping that if I can learn how this works, I can adjust as needed. Example: Jill Smith has two different accounts, and five rows of data. I either need her to have two rows total, or just one with all the info.

Please let me know if I'm not making sense, and thanks for your willingness to help teach newbies like myself.

Perhaps this will help:
The range is converted to a table so that when new records are added the formulas in the result range will reference the new rows automatically.
Another column is added and is populated using: =CONCATENATE(E2&", "&F2&", "&G2&", "&H2)
In the result the first column (K) is populated using: =IFERROR(INDEX(A$2:A$14,MATCH(0,INDEX(COUNTIF(K$1:K1,A$2:A$14),,),)),"")
The next three columns are populated using: =IF($K2="","",INDEX(B$2:B$14,MATCH($K2,$A$2:$A$14,0)))
The added column is pivoted into rows using: =IF($K2="","",IFERROR(INDEX($I$2:$I$14,AGGREGATE(15,6,(ROW($I$2:$I$14)-ROW($E$1))/($A$2:$A$14=$K2),COLUMNS($A$1:A$1))),""))
Let us know if you have any questions.