How do I combine multiple records for a single item?

D

DrStone98

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.
 
G

Gord Dibben

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
 
Top