I need to to change e.g.:
1 2 3 4
5 6 7 8
into:
1
5
2
6
3
7
4
8
And I need to do this with 500 columns. I have no experience doing this in excel so would very much appreciate getting a code that can do this.
Hi Faseeh,
sorry for the post here but have no clue of how to code in excel so really need a dummy code that will do it for me (copy/paste) and ideally one that I can extend to e.g. 500 columns.
Hello, I also need help in somewhat the same way, but then again not completely:
I need to convert this
1 2 3 4
5 6 7 8
into:
1
5
2
6
3
7
4
8
And have no experience in doing this in excel