How can I merge 3 time series data tables with different records

[PG808]

I want to create a single unified table that has all records across all 3 tables merged in a single table.
There are no duplicate records across the 3 tables

 

[Hui]

Is this a "one of" or something you need to do regularly?

 

[PG808]

Is this a "one of" or something you need to do regularly?

Hi Hui, it maybe something I have to do again, but right now it's a one off

 

[Hui]

PG

Please see attached file

It has a Macro in it "Join_Data"
Open the file and Alt F8
Select Join_Data
Run

It assumes the data layout is the same on each sheet
You can have as many Rows and Columns of data as you want and it adjusts automagically

Enjoy

 

[PG808]

PG

Please see attached file

It has a Macro in it "Join_Data"
Open the file and Alt F8
Select Join_Data
Run

It assumes the data layout is the same on each sheet
You can have as many Rows and Columns of data as you want and it adjusts automagically

Enjoy

thx Hui, looks great. I actually need the resulting data structure to be the same as the source. i.e with dates as column headers in chronological order running from left to right. Is that even possible?