Excel - General Question on Pivot Table - Expert Solution

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.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.