column / row merge sort

J

JD

I have a spreadsheet that consists of rows of names and
columns of data pertaining to that name information. If a
name has more than one occurance, that name has more than
one row. I want to consolidate all the data for one name
to 1 row.

Short of doing it all by hand is there a better way?


thanks in advance!
JD
 
D

Dave Peterson

Depends on what you want to do with the data and what the data is.

If it's just numeric data, it may be as painless as using a pivottable to
summarize it. If the data contains text, then maybe concatenating fields
(multiple lines in one cell?) or maybe you want to just add the info to unused
cells to the right.
 
D

Dave Peterson

Before you get any useful response, you're going to have to post some details.

The list of names is in what column?
The alpha data is in what columns?

And it doesn't matter about the order of the data after the copy?
 
Top