How to consolidate rows of data based on a single column?

Nolen

New member
Joined
Jan 22, 2014
Messages
1
Reaction score
0
Points
0
I am not sure of the proper place to post this, so please advise me if it should be put elsewhere...

I have a very large amount of data. ~29,000 lines. It is in this format currently:
ABCDEFGHI
182560000000
180512000000
180025600000
19710000000000
1909000000000
190000001400
203860000000
200077300000
200003860000
210290000000
210007080000
210000354000
21000003200


I would like to sort it all based on the value in Column A. Currently, each row has only 2 (non-zero) values. The first in column A, and another in only ONE of the other columns(B→I). I want to consolidate the rows according to the value in column A. The final product should look like this:
ABCDEFGHI
1825651225600000
1971000900000001400
2038607733860000
21029007083543200


How would I go about doing this?

Thanks in advance.
 
Top