Pivot to show top 5, However.....

[nparsons75]

I have a normal table of data, in most cases the data is vertical, however, within the table is some data that is horizontal, by this I mean running along the columns as opposed to in rows. I have managed to create a pivot table by adding calculated fields of the same data in the columns.

Although I have managed this I cannot sort the data A-Z.

I need to find the top 5 items from the data.

Is this possible at all?

Thanks in advance....

 

[nparsons75]

Hi,

Yes I do see get and transform, something I have never used to be honest.

 

[RoryA]

You can use that to 'unpivot' your columns. Many examples out there: https://www.youtube.com/watch?v=0WBgD0l5r-4

 

[Joyner]

You can also see here for a similar problem, this links to a Mrexcel video on how to unpivot:

https://www.mrexcel.com/forum/excel...lti-level-table-format-maybe-pivot-table.html