Is there a formula that can split data from 1 column to 3 columns as follows
Column A has data from cell A1 down
1
2
3
4
5
6
7
8
9
I would like it to look as follows in Columns C to E
C D E
1 2 3
4 5 6
7 8 9
Thanks for any help
Is there a formula that can split data from 1 column to 3 columns as follows
Column A has data from cell A1 down
1
2
3
4
5
6
7
8
9
I would like it to look as follows in Columns C to E
C D E
1 2 3
4 5 6
7 8 9
Thanks for any help
Welcome to the forum
Please try the following in C1 copied across and down to E3:
Formula:Please Login or Register to view this content.
Let me know if this does what you need.
Geoff
Did I help significantly? If you wish, click on * Add Reputation to say thanks.
If your problem has been resolved please select ?Solved? from the Thread Tools menu
Thanks GeoffW283, that worked perfectly
Just thinking of other ways to use this down the line
If I wanted to put the data in alternate rows C, E & G how would I change the formula
Thx
The following formula copied to the appropriate columns will do it for your specific example of alternate columns:
Formula:Please Login or Register to view this content.
I don't have a generalized algorithm. For me at least it's just a case of playing with row(), rows(), column() and columns() and possibly int() and mod() until you get the index into col-A that you want. I find it easier to temporarily remove the index() part of the formula while doing this.
Hope that helps!
Thanks again GeoffW283, most helpful
No problem - thanks for the reputation points
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks