I have a list of people that have individual records (rows) for several
items. I would like to combine the data into one row per person with
additional columns for the data that used to be in the additional rows.

Is there a pattern to the records/rows?

i.e. four rows then next set of records repeated?

Assume four as above.

In B1 enter =INDEX($A:$A,(ROWS($1:1)-1)*4+COLUMNS($A:B)-1)

Copy across to E1 then select B1:E1 and copy down untill you get zeros.


Gord Dibben MS Excel MVP

On Mon, 30 Apr 2007 12:30:02 -0700, DrStone98
wrote:

I have a list of people that have individual records (rows) for several
items. I would like to combine the data into one row per person with
additional columns for the data that used to be in the additional rows.