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