Transposing into a single column

[excelater]

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.

[mike7952]

This should work

Please Login or Register  to view this content.

[excelater]

Thanks for the response Mike. That solved part of the problem. The data I have is really long which is why I only gave only a small example of what I was talking about, but some of data might have 4 lines of data and others 1 line which why when i run the code it says out of range. Here is a picture that shows a little better description of what I am talking about.

example.PNG

[mike7952]

I edited the code in my previous post from my phone, I'm not at a computer to test.

[excelater]

Thanks for responding especially on your phone. Its works but it does space it out differently, but thats easy enough to remove. Thanks a lot.