Hi and welcome
please post a sample sheet ( no pics please)
You can try the "Group" option in the PT menu after selecting the row fields you want
(see Grouping Text Items at https://www.contextures.com/xlPivot07.html)
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
|