Create pivots with numeric data in multiple columns instead on one column

Hi,

Currently my data looks like this:
Col1 Col2 X Y Z
A D 20 40 60
B E 99 25 36
C F 14 25 48

However, I want to be able to convert the data into one column so I can easily pivot it

Col 1 Col2 Value
A D X 20
A D Y 40
A D Z 60
B E X 99
B E Y 25
B E Z 36
C F X 14
C F Y 25
C F Z 48

This is just a small example but the original data i have is about 100 rows and 200 Column. But i cant pivot it properly now because all the values are currency in the 200 columns which means in a pivot table I will have to put all the columns in the "Value" feeds and I wont have a choice to organize them into rows or columns as required.

Please let me know if there is a macro or any other trick to do that.

Thanks.