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.

Similar questions and discussions