SOLVED
Help Parsing Data
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
fitzviz
7 - Meteor
‎10-26-2017
08:40 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi,
I have a bunch of records that I am trying to parse from single cells to multiple cells. Example is below any ideas for how to get this result would be great!
Start with:
A,B,C |
D,E,F |
End with:
A |
B |
C |
D |
E |
F |
Solved! Go to Solution.
Labels:
3 REPLIES 3
jrgo
14 - Magnetar
‎10-26-2017
08:49 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @fitzviz,
Text To Columns tool is what you need!
Attached is an example. Hope this helps!
Best,
Jimmy
‎10-26-2017
10:08 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Did not notice you could split to rows that is awesome thanks!
jrgo
14 - Magnetar
‎10-26-2017
10:09 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
