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.
