Transpose stacked lists of values
 

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

Transpose stacked lists of values
 

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

"Joe" wrote in message
...
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