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...
That works when the null spaces are at the start or end, but I'm actually trying to apply this solution to many columns at once ( I should have mentioned this) and the TRIM function does not seem to work for extra spaces between text.
Anonymous: I would like to know how to shift cells too. Did you ever come up with a solution?
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.
