Transposing with dynamic row records Help needed VBA

[kuoyen23]

Hi gurus.

I am trying to convert a data table( see attach "input" file) into single column ( see "output" file)
appreciat you can guide me on where to start ? Thank you.

 

[Joe4]

Welcome to the Board!

As you have discovered, you cannot attach files. But there are tools you can use to post screen images. They are listed in Section B of this link here: http://www.mrexcel.com/forum/board-a...forum-use.html.
Also, there is a Test Here forum on this board that you can use to test out these tools to make sure they are working correctly before using them in your question.