Transposing values One after the other

[Shivay108]

Hi Guys,

I have data in multiple rows and i want to transpose the data into one column one after the other. i have to do it right now manually and it is very time consuming. Is there any way or formula to do it quicker.

The format of data i have is:

the way I would like to have it is:

I would like have it transposed automatically one after the other rather than transposing and then pasting one column and other after the previous one manually.

Thank you

 

[Michael M]

We can't see images residing on your hard drive !!
There are a number of ways to attach to this forum...see here...

https://www.mrexcel.com/forum/about-board/508133-attachments.html


OR
Upload to DropBox and post a link back here !!!