Hello all,
What is the best tool available within excel to organize or merge multiple tables?
I download a CSV file with multiple rows and columns of data from an external source every week and I’m not sure how to “merge” them together into one file. I want to include any notes I originally wrote along with the date that changes were made and discard any duplicates.
For example, I may receive a request to change figures in accounting but it may take accounting 3 weeks to resolve. The outside CSV file will continue to list the accounting data until it’s cleared. I want the note I created the 1st week to display that the item has already been touched and is awaiting correction. Is it possible to sync?
What is the best tool available within excel to organize or merge multiple tables?
I download a CSV file with multiple rows and columns of data from an external source every week and I’m not sure how to “merge” them together into one file. I want to include any notes I originally wrote along with the date that changes were made and discard any duplicates.
For example, I may receive a request to change figures in accounting but it may take accounting 3 weeks to resolve. The outside CSV file will continue to list the accounting data until it’s cleared. I want the note I created the 1st week to display that the item has already been touched and is awaiting correction. Is it possible to sync?