SOLVED
Moving the data to new column based on empty row
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
SH_94
11 - Bolide
‎09-22-2022
10:43 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Dear community,
Would like to seek for help on how to moving the data to new column for the example below: The concept is if the column under GL is empty ( it may have multiple empty rows), then the extract the data from the first empty row in the description column copy to new column called " Remarks".
Many thanks
Solved! Go to Solution.
Labels:
- Labels:
- Common Use Cases
2 REPLIES 2
binuacs
21 - Polaris
‎09-23-2022
12:12 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎09-23-2022
01:32 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank @binuacs for the great idea on how to massage the data . I understand the concept and will apply it my cases.
Thanks again for the sharing.
