Plain basic table from a Pivot

[NikkiT]

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

[MarvinP]

Hi NikkiT and welcome to the forum,

It sounds like you need a Table instead of a Pivot Table. Using a Table Auto Filter on a single sheet might do what you want. Although, I believe you are really asking for using an Advanced Filter on your data and putting subsets of it on different sheets. Time to learn about Advanced Filters? https://support.microsoft.com/en-us/...8-3f16abdff32b
or https://www.bing.com/videos/search?q...tail&FORM=VIRE

[NikkiT]

Yes - I am looking for a way for it to automatically split it to the separate worksheets - which Pivots will do.

basically, it is data from 35 different wards. I just need to display the data, separately, for each ward. And as it will be done daily at the moment, I want to save my sanity (and time) and not filter / copy / paste it all into the 35 worksheets!

Is this something an advanced filter will do? I'm new to 365 and the changes are pretty immense!

[NikkiT]

To explain my thinking slightly more

In a pivot table, I can do "show report filter pages". That's what I need to do.. but have the data displayed in an easy to read (and easy to apply conditional formatting to) table.

[rorya]

You should be able to achieve that by putting all the fields into the row area.

[NikkiT]

That's what I thought. And I used to be able to do that. But since having upgraded to 365 a few weeks back, Pivot is so different to what I am used to.

[rorya]

Where are you stuck exactly?

[NikkiT]

Laying the pivot table out as a table!! It nests everything

[rorya]

On the Design tab, set the layout to Tabular.

[NikkiT]

You're a genius!!!!!!! Needs a bit more playing with, but you've got me 90% of the way there!!!

[rorya]

Glad we could help.