Creating a table, from data which is another table?

[WGBarry]

Hi guys, I am wondering if anyone can be of help to me?

I currently have a table which is about 44000 rows by 18 columns. The data in this table I would like to some what make easier to read by creating tables on new worksheets in the same workbook, so that, as an example the total P&L of the P&L column (column R) in the month of January 2008 (column A) and then February 2008 through each month until February 2014 if that makes sense?

Any help will be much appreciated.