Hi I believe it is very simple but I am not very advanced in Excel. Was searching a lot , found more complicated things with operations on numbers etc and couldn't find how to do it. I dont want to sum anything , just put two tables together by date.
I have two tables with a few colums (same column headers), one of which is date / time.
so lets say first table looks like this:
DAY number of people
Mon 5
Wed 34
Sun 54
Sat 22
table 2
DAY NUMBER of people
Tue 7
Thu 8
Fri 11
I want end result to be:
Mon 5
Tue 7
Wed 34
Thu 8
Fri 11
Sun 54
Sat 22
(it is indexed by time and that is what I want)
I have a few tables with same column headers, but lets say there are 2 , I dont mind to go one by one if it is easier.
There is though more columns to my table - I hope that doesnt matter. I want it to be merged and indexed by time column.
THANKS A LOT !!!!!!!!!!
Bookmarks