Question description:
This user has given permission to use the problem statement for this
blog.
Is it possible to unpovot part of a Pivot table.
Solved by M. H. in 4 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
27/09/2018 - 05:59
Hello, Welcome to Got it Pro.
User
27/09/2018 - 06:00
hi
Excelchat Expert
27/09/2018 - 06:00
Please forward the working sheet or add some sample data so that I can help you better.
User
27/09/2018 - 06:00
I don't have a sample just a question. Just wanted to ask is it possible to unpivot part of a table and not leave the rest of the table as a pivot
Excelchat Expert
27/09/2018 - 06:01
Ok, So when you create a pivot.. There is a base data from which you create the pivot
Excelchat Expert
27/09/2018 - 06:01
pivot is separate from the base data
Excelchat Expert
27/09/2018 - 06:02
in pivot you can select the rows, columns, values to be displayed and you can always change the source (base) data
Excelchat Expert
27/09/2018 - 06:03
So you can always change the pivot, its source, look/ design, values and so on.
Excelchat Expert
27/09/2018 - 06:03
without affecting the base data
Excelchat Expert
27/09/2018 - 06:03
Does this solve your query?
User
27/09/2018 - 06:03
Yes actually it does thank you very much!
Excelchat Expert
27/09/2018 - 06:03
Please end the session, I will appreciate a 5 star rating. I will also provide a 5 star rating for you so that you get the best expert next time.
User
27/09/2018 - 06:03
Sure :)
Excelchat Expert
27/09/2018 - 06:03
Thanks for using Got it Pro. Looking forward to help you further. Appreciate it :)
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.