How to export only the first top 3 rows from pivot and put it in 3 coloumns with info

[Peter92]

Hello there,

I have the attached situation and dunno how to automate it. There is a lot of Headlines and Contents with information.

Has anyone an idea maybe also via vba if not possible otherwise?

Important: The attached information are all in a pivot table and not just in normal cells.

Hope you understand, what I'm trying to do haha

All the best,
Peter

[CK76]

Without raw data underlying Pivot, bit difficult to help you. I'd recommend you upload that.