Combining Multiple Rows into one while preserving unique cell values?

Good morning,

I hope that you can assist me. I am working on a massive spreadsheet where there are columns with individual account numbers, and rows with duplicate names. What I am trying to do is take the rows with duplicate values and merge them, while preserving any unique account number placed in the column.

I cannot take this to access because the file is needed for an interface data dump and I must be able to convert it to pipe delimited later.

The spreadsheet is huge, with over 300,000 rows. I even tried to remove the duplicate values in hopes I'd be able to see what files were purged, but that didn't work and only told me that 71,584 duplicate rows were removed (which of course removes the account numbers that were in the columns.)

PLEASE HELP! I've added an attachment, though the real file has multiple columns. (58 to be exact.)

I am working in Excel, 2007 office version.

Thank you!

Use a pivot table and map the columns and rows back to the original layout.

HTH

Hello Excel Experts,

Please help me solve my problem. I need to combine "unique" values from multiple columns/cells into one cell (separated by commas). Preferably they are also sorted in ascending order. Data file attached.

Please note, that where same "student" appears more than once, all unique "scores" from all rows and columns must also be combined into one cell (also in ascending order).

I hope I made myself clear.

Thanks and best regards to all,

CMC