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.
Bookmarks