Merging rows
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
tf05
7 - Meteor
‎02-25-2022
05:56 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I have joined two data sets, both with similar data. On those that I have matched, I need to update the missing cells in input 1 with the data in the input 2 input, without overriding the data already n the input 1 if it isn't empty.
I know I can merge the cells using an IF IsEmpty formula but I am looking at having to duplicate the formula about 50 times to merge all the data.
Is there an easier way to do this?
Labels:
- Labels:
- Join
1 REPLY 1
‎02-25-2022
05:59 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Issue resolved apologies
