virtualized
New Member
Hi Everyone
I have some data in a cell in the form:
0 0 0 0 0 0 0 0 0 0 9 0 0
I want to move it to a column and each number goes to exactly one cell of the column.The final output should be like this:
0
0
0
0
0
0
0
0
0
0
9
0
0
The minimum number in my data is 0 and the Maximum is 100.
I have tried to do it using Transpose in Paste Special but it did not work.
Any help in this regard is highly appreciated.
Best Regards
I have some data in a cell in the form:
0 0 0 0 0 0 0 0 0 0 9 0 0
I want to move it to a column and each number goes to exactly one cell of the column.The final output should be like this:
0
0
0
0
0
0
0
0
0
0
9
0
0
The minimum number in my data is 0 and the Maximum is 100.
I have tried to do it using Transpose in Paste Special but it did not work.
Any help in this regard is highly appreciated.
Best Regards
