Removing Duplicates but merging the rows with missing information
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
wingtc99
6 - Meteoroid
‎10-04-2021
06:02 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi, I have merged two sets of lists together, now I am trying to get a unique list. The problem is that list 1 is does not contain the middle 3 columns, which results in a null.
I have used the unique tool, however it removes rows with full sets of data and leaves the rows with nulls as a unique row, is there a way to merge and auto fill this so that I could get a row such as:
Armada Boat Hire, XYZ, 123, XYZ, XYZ.
Thanks
Labels:
- Labels:
- Join
1 REPLY 1
Christina_H
14 - Magnetar
‎10-04-2021
06:05 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
The unique tool will always take the first row for each item, so just sort it to make sure the populated rows come first.
