Dynamic display of various size arrays that actually works?

[excelos]

Hello!

I am looking to filter an array and display the dynamic contents (various number of rows and size of data inside each cell but constant columns).

• I have tried to set Autofit Row Height but it does not seem to work well.
• I tried to use the Camera feature and it distorts the image.

Do you have any other suggestion?
I will be considering putting the array in a structured table as my last resort if nothing else works.

Thanks!

 

[James006]

Hello,

Have you tried to insert a Pivot Table ???