Transposing data

[tamits]

I am trying to transpose 2 columns one of which has header and other column has data in it. I have attached excel which has 2 tabs named 

[Kamran1991]

This will help you, just need to rearrange the order of fields.

[binuacs]

@tamits One way of doing this

[tamits]

Thank You! both Solution works just fine. My actual data is text rather than Numbers i hope it will work same way on text as well...