Forum Discussion
Moving a column of text data into 3 columns of data?
I have a column of text data cells 1,2,3,4,5,6,7,8,9 and longer.
I want to create 3 column of data to graph and manipulate
Cell in Columns.
1,2,3
3,4,5
5,6,7
8,9,10
and longer.
So i need to create 3 columns of data from 1 column of data.
I am using Mac Excel 16 and I can not make this happen. I have tried all sorts of solutions.
Help?
Thank you,
3 Replies
Hi Bob_Myers ,
Can you paste a screenshot of
- What you have exactly (sample)
- What you'd like it to be
My brain says that MAYBE in your example you didn't REALLY mean:
Cell in Columns.
1,2,3
3,4,5
5,6,7
8,9,10
but rather:
Cell in Columns.
1,2,3
4,5,6
7,8,9
...and so on.
The sequences you expressed {1,2,3;3,4,5;5,6,7} seems doable - but if this is really what you want I would have expected the next set of three in the sequence to be {7,8,9}, NOT [8,9,10}
So give us a picture to remove confusion. :)
HR is right, i have done this with the help of vba
For Excel-2016 it would be difficult. Power query or VBA needed. You can achieve it easily by formula in Microsoft Excel 365.
