I need to do an archive from a table with lots of blanks.
Basically, any new addition to the table will move forward one column even if all the row under the new addition remain empty. Every time the date is written, even if it’s the same for 50 addition.
The copy/paste wouldn’t work in this case because I need to have access to only the total movement of the day.
2 problems here for me, how to get only the cells with a value and put them in a column, and how to get only one line per date ?