how to transform data from row-base to column-base

I have excel data like below

A	12
A1	34
A	45
A1	78
A	45
A1	76

I want to transfer to below:

A	A1
12	34
45	78
45	76

this is a simplified sample, in the real data, there are 20 labels, from A1 to A20. however the data is like above, from A1 to A20 then repeat A1 to A20... total over 1 million rows.

Thanks.

hi Sixthsense,

thanks for the reply, that's very clever use of pivot table!

however it is not exactly what I want to achieve. See my attachment excel. see attached excel file.

Of course I could just use your solution and then do some manual copy&past.

Thanks.