How do I take Multiple Rows with all columns Unique with the exception of 1 to 1 Row?

Hello,
I need some help taking multiple rows of data where all of the data is the same with the exception of the last column and combine that data so that there is only one row of data and additional columns to accommodate the data. I am not familiar with VBA or Macros.
The excel spreadsheet I am working with has 170,000 records of which probably close to 100,000 are unique
Each unique record could have close to a Max of 10 Attributes - they can range from 1 Attribute to 10
Your assistance is appreciated!


CURRENT VIEW
ID Alt ID AltOtherID Unique Identifier FirstField First Date MaxField Attribute
1 123 4444 ABC 2 1/1/2012 5 ABC
1 123 4444 ABC 2 1/1/2012 5 DEF
1 123 4444 ABC 2 1/1/2012 5 GHI
1 123 4444 ABC 2 1/1/2012 5 JKL
2 555 6666 CCC 3 2/1/2012 7 ABC
2 555 6666 CCC 3 2/1/2012 7 DEF
2 555 6666 CCC 3 2/1/2012 7 GHI
2 555 6666 CCC 3 2/1/2012 7 JKL
2 555 6666 CCC 3 2/1/2012 7 MNO
3 666 888 DDD 4 2/2/2012 8 MNO
3 666 888 DDD 4 2/2/2012 8 XYZ
3 666 888 DDD 4 2/2/2012 8 PQR

DESIRED VIEW
ID Alt ID AltOtherID Unique Identifier FirstField First Date MaxField Attribute1 Attribute2 Attribute3 Attribute4 Attribute5
1 123 4444 ABC 2 1/1/2012 5 ABC DEF GHI JKL
2 555 6666 CCC 3 2/1/2012 7 ABC DEF GHI JKL MNO
3 666 888 DDD 4 2/2/2012 8 MNO XYZ PQR

See the attached

Thank you for your reply.
So I tried this and I can't get it to work - the first column isn't actually 1, 2, 3 - it's unique ID's like 2222, 3232, 2333.
Would that make the VLokup different?

CURRENT VIEW
ID Alt ID AltOtherID Unique Identifier FirstField First Date MaxField Attribute
2223 123 4444 ABC 2 1/1/2012 5 ABC
2223 123 4444 ABC 2 1/1/2012 5 DEF
2223 123 4444 ABC 2 1/1/2012 5 GHI
2223 123 4444 ABC 2 1/1/2012 5 JKL
2262 555 6666 CCC 3 2/1/2012 7 ABC
2262 555 6666 CCC 3 2/1/2012 7 DEF
2262 555 6666 CCC 3 2/1/2012 7 GHI
2262 555 6666 CCC 3 2/1/2012 7 JKL
2262 555 6666 CCC 3 2/1/2012 7 MNO
2111 666 888 DDD 4 2/2/2012 8 MNO
2111 666 888 DDD 4 2/2/2012 8 XYZ
2111 666 888 DDD 4 2/2/2012 8 PQR

Thank you Mike!!!!!

Originally Posted by mike7952

See attached macro version. Click button.

Attachment 192410