This is probably very basic, and I am missing something entirely.

I have approx 8000 rows of data, that need splitting depending on columnA (35 different options).

What I would like, is to have a very basic Pivot table that doesn't do any calculations or totalling.. just displays the data from the main sheet, which I can then use a filter in the pivot to automatically split these into separate worksheets.

I just can't, for the life of me, build a simple table, with 7 columns that bring the data from the 7 columns in the main sheet. Like a cut and paste, but without the hours work involved every single day!

Thank you in advance for any help you can offer