for example,
214 235 456 746 852
741 963 789 123 753
951 357 654 258 258
need to convert,
214
741
951
235
963
357
456
789
654
746
123
258
852
753
258
for example,
214 235 456 746 852
741 963 789 123 753
951 357 654 258 258
need to convert,
214
741
951
235
963
357
456
789
654
746
123
258
852
753
258
Use Text to columns from Data tab and select "space"
This should do what you want:
Formula:Please Login or Register to view this content.
A B C D E F G 2 214 235 456 746 852 214 3 741 963 789 123 753 235 4 951 357 654 258 258 456 5 746 6 852 7 741 8 963 9 789 10 123 11 753 12 951 13 357 14 654 15 258 16 258
If your data starts in row 1:
Formula:Please Login or Register to view this content.
Last edited by newdoverman; 08-08-2015 at 11:13 AM.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
Try this...
Data Range
A B C D E F G 1 2 214 235 456 746 852 ---- 214 3 741 963 789 123 753 741 4 951 357 654 258 258 951 5 235 6 963 7 357 8 456 9 789 10 654 11 746 12 123 13 258 14 852 15 753 16 258 17
This formula entered in G2:
=IF(ROWS(G$2:G2)>COUNTA(A$2:E$4),"",OFFSET(A$2,MOD(ROWS(G$2:G2)-1,3),INT((ROWS(G$2:G2)-1)/3)))
Copy down until you get blanks.
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks