How to transpose cells in Execl with limiting the header columns? : Sorry for the bad explanation of the title but it is hard to me to explain what i am facing by words let me show you the problem i have sheet full of data as the next screenshot :

[![the sheet][1]][1]


All i need transpose the data with limiting the header columns to one row then the data comes after. 

Note : the headers is A column and B is the Data.

Example for the result required :

[![enter image description here][2]][2]

Please offer me a help or workaround thanks in advance .


  [1]: https://i.stack.imgur.com/fxPjr.png
  [2]: https://i.stack.imgur.com/cLhAi.png