Pivot tables Headache

[dessim]

Evening Folks,
I have some issue with Pivot Tables.

Don mind bear with me & advise some solutions ifpossible.Greatly appreciated.

I have this pivot Overview Sheet here. Whenclick on John Value 5 to access the internal data -->Sheet 4 will be createdand it looks something below:

Sheet 4 will appeared as seen above. all the data will be "squeezed" with the columns.

1) Is there any method to autofit the content within each individual cells (to show the hidden content)
rather than to manually have to use "wrap text function"

2) how to auto align all the datas with cells automatically.

any solutions to the above ?

Thanks


<!--[if !supportLineBreakNewLine]-->
<!--[endif]-->

 

[dessim]

seeking kind assistance for the above. Thank you people.

 

[dessim]

any advice..Thank you