SOLVED
Append Field by joining data from same source
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
timewaste
8 - Asteroid
‎11-01-2017
10:42 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi Peers,
Newbie here. How can I accomplish this? The data in column E should be same as data in column A. TIA!
Source Sheet (for both sources - columns A,B,C,D and E):
A | B | C | D |
1 | b1 | c1 | d1 |
2 | b2 | c2 | d2 |
3 | b3 | c3 | d3 |
Target Sheet:
A | B | C | D | E |
1 | b1 | c1 | d1 | 1 |
2 | b2 | c2 | d2 | 2 |
3 | b3 | c3 | d3 | 3 |
Workflow:
Solved! Go to Solution.
Labels:
- Labels:
- Preparation
3 REPLIES 3
JoshKushner
12 - Quasar
‎11-01-2017
11:01 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
JoshKushner
12 - Quasar
‎11-01-2017
11:26 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Or if you're saying how do you create column E from a single input that has columns A-D then use the formula tool to create a new column equivalent to A:
Flow:
Results:
Formula:
‎11-01-2017
11:58 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks once again!
