combine two worksheets with same headers into a pivot table

[dreadnaught]

I currently have two work sheets with 5 columns each both identical headers but different time frames. I would like to combine the two into one pivot table. I have been unable to get the 5 header items seperate in the pivot table. Any suggestions.

 

[dianemarie]

I would add a column on the first worksheet called Date Range, and fill in that column for all records on the first worksheet as Date Range 1. Then copy the block of data from the second worksheet and paste below the first block of data (no headers or blank rows), and fill in the Date Range column for all those records as Date Range 2. Now you'll be able to pivot the table, and use Date Range 1 and Date Range 2 however you need them.

 

[dreadnaught]

I should have added this, I have about 120,000 lines in total from the two work sheets so adding them together will not work.