Continuing Data
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi everyone!
I wonder if anyone will be able to help me with the following. I have two columns of data and I am wanting the data in column 2 to start on the next row of column 1.
Column1 Column2
[null] A
B C
D E
F G
And i'm wanting the output to be the following:
Column1 Column2
[null] A
A B
B C
C D
D E
E F
F G
I'm not sure how to go about this, so any help or tips appreciated...Many thanks!
Solved! Go to Solution.
- Labels:
- Data Investigation
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
A multi-row formula tool, where Column1 = [Row-1]:[Column2]
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @JH123
I have built a workflow out to achieve your output.
I created two streams, one for Column1 and one for Column2, then joined by record position to drop off the last part.
Let me know if you have any questions.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Many thanks @JoeS ! Worked perfectly 🙂
![](/skins/images/A29875142F332EEF75F19ED75711F41B/responsive_peak/images/icon_anonymous_message.png)