Combine data from two sheets

Hi,
I am trying to combine two sheets together. In the attached example, I have data in sheet "1" and "2", I want to combine the data in sheet "3". I tried INDEX and MATCH functions but it is difficult to get the data from two sheets and skip rows. I have about 300 rows and 75 column. Any idea?

Copy one table to the other sheet and create a pivot table. See attached. I recognize that you have more data but this can be done very simply and straight forward.

Look at my signature block for the Pivot Table Tutorial. They will show you the power of Pivot Tables. A very powerful Excel tool.

Alan