I have a number of column data in MS excel sheet. I need to rearrange them in a single column, but not by copy paste. I need the formula to do it.
INPUT:
A B C
1 One Two Three
2 Four Five Six
Expected OUTPUT:
A
1 One
2 Four
3 Two
4 Five
5 Three
6 Six
See the link to understand the question also open the attached excel file please.
http://forum.openoffice.org/en/forum/viewtopic.php?t=56505#p248560
Thank you.