Deleting unwanted empty row cells
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
Gsiva3
8 - Asteroid
‎04-13-2023
06:18 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I have 4 columns named as A,B,C,D. have one empty row value in one column and on some of the columns I have 2 or 3 empty values. So the thing is the empty row above the cell value "Remain" has to be retained and all the other empty row values has to be removed from all the columns.
Please help me on this
INPUT | |||
A | B | C | D |
AA | ko | QW | MH |
kl | NB | ||
CD | DF | VG | |
GB | jn | GV | |
HJ | po | BH | YT |
Remain | Remain | Remain | Remain |
OUTPUT | |||
A | B | C | D |
AA | ko | QW | MH |
CD | kl | DF | NB |
GB | jn | GV | VG |
HJ | po | BH | YT |
Remain | Remain | Remain | Remain |
Labels:
- Labels:
- Data Investigation
4 REPLIES 4
cjaneczko
13 - Pulsar
‎04-13-2023
06:49 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
cjaneczko
13 - Pulsar
‎04-13-2023
06:56 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
In reviewing it looks like the Data Cleansing tool is reordering the data in each field. The flow I posted needs some tweaking.
‎04-13-2023
07:03 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Yes. And I not only have 4 column. In my actual input I have more than 20 column. Hence it is not possible to separate all the 20 columns using select tool. Is there any other way to do this?
SPetrie
13 - Pulsar
‎04-13-2023
07:39 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
