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