Transpose stacked lists of values

[Joe]

I have a column with repeating labels, and a second column with values.

Example:

Column A Column B
Label1 Value1
Label2 Value2
Label3 Value3
Label1 Value4
Label2 Value5
Label3 Value6
Label1 Value7
Label2 Value8
Label3 Value9

I need to transpose these so that the Labels in column A become column
headers, and the corresponding values for each label appear in the rows below
each column header.

Example:

Label1 Label2 Label3
Value1 Value2 Value3
Value4 Value5 Value6
Value7 Value8 Value9

Can anyone help?

Thanks!
Joe

 

[Ashish Mathur]

Hi,

You could try this. Suppose the data below is in range B4:C13 (row 4 is the
header row). In D4, enter ="Occurrence"&COUNTIF(B$5:B5,B5) and copy down
till D13. Now create a pivot table from it - drag column B to the column
area, column D to the row area and column C to the data area.

Hope this helps.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com