**Question description:**

*This user has given permission to use the problem statement for this blog.*

I need to be able to convert a pivot table of 4 columns and 100 rows into two tables of 4 columns and 50 rows each? How might I do this?

Solved by X. F. in 20 mins

This is the chat thread from the real Excelchat help session. It contains no private user information.

Excelchat Expert
04/04/2018 - 05:34

Hi welcome to Gotit

User
04/04/2018 - 05:35

I do data analysis using Excel and pivot tables for a theological seminary.

User
04/04/2018 - 05:36

I use Excel 2016

Excelchat Expert
04/04/2018 - 05:36

ok

User
04/04/2018 - 05:37

I need to be able to convert a pivot table of 4 columns and 100 rows into two tables of 4 columns and 50 rows each? How might I do this?

Excelchat Expert
04/04/2018 - 05:37

we can split data source and create two pivot table?

User
04/04/2018 - 05:38

how do you do that?

Excelchat Expert
04/04/2018 - 05:38

Can you share your sheet?

Excelchat Expert
04/04/2018 - 05:38

or any example data sheet

User
04/04/2018 - 05:39

should I input it into the document preview sheet 1

Excelchat Expert
04/04/2018 - 05:40

yes

User
04/04/2018 - 05:42

so now how would I divide this into two tables with 4 rows in one table and 3 rows in the other, both having two columns?

Excelchat Expert
04/04/2018 - 05:44

Where is the source for this pivot table?

User
04/04/2018 - 05:44

on sheet 1

Excelchat Expert
04/04/2018 - 05:44

ok

Excelchat Expert
04/04/2018 - 05:46

Why you want to split pivot tabe?

User
04/04/2018 - 05:47

I am trying to get the table onto a dashboard and it is too long (too many rows) to fit nicely on a dashboard so I want to go side-by-side

Excelchat Expert
04/04/2018 - 05:48

you can use slicer and by selecting required thing we will get that values right?

Excelchat Expert
04/04/2018 - 05:48

If you want 2 pivot tables side by side

Excelchat Expert
04/04/2018 - 05:49

we have to split source data into two and generate pivot table with that

Excelchat Expert
04/04/2018 - 05:49

is that ok for you?

User
04/04/2018 - 05:49

OK, but I don't have unique data to filter on like i.e. greater than or less

User
04/04/2018 - 05:50

In my example, I suppose I can filter on campus and put 3 campus on one table and 4 campus on another table. Is that the way I would need to do it?

User
04/04/2018 - 05:51

Thanks

User
04/04/2018 - 05:52

Good-bye

Excelchat Expert
04/04/2018 - 05:52

Wait

Excelchat Expert
04/04/2018 - 05:52

yes

Excelchat Expert
04/04/2018 - 05:52

I will share you a sheet with example

Excelchat Expert
04/04/2018 - 05:53

Check this

[Uploaded an Excel file]

Excelchat Expert
04/04/2018 - 05:53

You can hide and also you can apply'

**This is the output file from the real Excelchat help session:**

*This is an example of the expert help you can get. It contains no private user information.*