SOLVED
NEED URGENT HELP: Separating rows into 3 columns
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
Sivory18
7 - Meteor
3 weeks ago
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi guys, as you can see all the data is in 1 row but need to separate it into 3 columns. I think I have to use the text to column but just don't know what settings to put down.
Solved! Go to Solution.
Labels:
- Labels:
- App Builder
- Connecting
3 REPLIES 3
18 - Pollux
3 weeks ago
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
What have you tried so far? Have you tried to split by text to columns on the space while also selecting skip empty columns?
3 weeks ago
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Could you help me to do with this please. The first screenshots shows the before and the second is what I want to look after.
18 - Pollux
3 weeks ago
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
This is a different question, so it may be worth posting this one specifically.
but similar solution - text to columns skipping empty columns, then you can do your additional splits with a formula tool afterwards
