Hi,
I have a Table that is in columnar data so I can do Pivot and other stuffs. This is for a restaurant data that I am organising.
There are a total of 3 tables (with consistent Field name). All 3 tables are being updated by different person. So, periodically they send me the updated tables in running columnar data down the rows (we're now at +2000 plus rows). All 3 tables show the same information (ie. raw materials purchases of the restaurant)
As they are the same info - I want to consolidate the 3 tables automatically - so I will then use this, let's call it, "Consolidated Table", to do Pivots and other stuffs.
What is the best way of doing it? As data changes daily - and reports are being sent periodically to me - surely there is a better way than what I am doing now - checking the last updated day transactions - and copy pasting the new transactions to a "manual" consolidated table that I do.
I have a Table that is in columnar data so I can do Pivot and other stuffs. This is for a restaurant data that I am organising.
There are a total of 3 tables (with consistent Field name). All 3 tables are being updated by different person. So, periodically they send me the updated tables in running columnar data down the rows (we're now at +2000 plus rows). All 3 tables show the same information (ie. raw materials purchases of the restaurant)
As they are the same info - I want to consolidate the 3 tables automatically - so I will then use this, let's call it, "Consolidated Table", to do Pivots and other stuffs.
What is the best way of doing it? As data changes daily - and reports are being sent periodically to me - surely there is a better way than what I am doing now - checking the last updated day transactions - and copy pasting the new transactions to a "manual" consolidated table that I do.