(Solved) – Copying a cell from an other cell address

  • by

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 table I have

The copy/paste wouldn’t work in this case because I need to have access to only the total movement of the day.

Where I need to archive it

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 ?

Leave a Reply

Your email address will not be published. Required fields are marked *