Forum Discussion
Shift data left to null cell
I'm wondering if it is possible to replicate the Excel trick where you select all empty cells using crtl-g, delete values and shift cells left. I'm exporting and merging data from 100s of pdfs and ev...
Hi,
Share some data and show the expected result.
Ashish_Mathur: I need to pull this data weekly for reports, but the system shifts the column name when exporting it to a CSV file. Thank you for any tips you can give.
Before >>>
| Part # | Part | Type | <--Shift Left-- | Date | <--Shift Left-- | Quantity Before | |
| 288 | Adult 3 Ply Face Masks (disposable) | Update | 7/23/2020 8:27 | 0 | 97.95 | ||
| 288 | Adult 3 Ply Face Masks (disposable) | Update | 7/23/2020 8:47 | 2156000 | 97.95 | ||
| 288 | Adult 3 Ply Face Masks (disposable) | Update | 8/3/2020 16:21 | 2156000 | 0 | ||
| 288 | Adult 3 Ply Face Masks (disposable) | Update | 8/3/2020 16:24 | 3565650 | 0 |
After >>>
| Part # | Part | Type | Date | Quantity Before | Quantity After |
| 288 | Adult 3 Ply Face Masks (disposable) | Update | 7/23/2020 8:27 | 0 | 97.95 |
| 288 | Adult 3 Ply Face Masks (disposable) | Update | 7/23/2020 8:47 | 2156000 | 97.95 |
| 288 | Adult 3 Ply Face Masks (disposable) | Update | 8/3/2020 16:21 | 2156000 | 0 |
| 288 | Adult 3 Ply Face Masks (disposable) | Update | 8/3/2020 16:24 | 3565650 | 0 |
Hi,
Simply delete the columns with the heading of Date and Quantity before and rename the columns with no headings to Date and Quantity before.