I am trying to get data in rows transposed into a single column with the first column being used as the heading and the second column the data that correspond to the information in the rows.

Like in the image

excel.PNG

I have code to transpose into a single column and code to insert empty cells based on row count but unable to get figure out how to get a code to do what I need.