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