CODEWITHSUNDEEP
excelpivot-tablemultiple-columns
anita chacko
anita chacko

Reputation: 1

Pivot data values to row

I have a pivot table from the below data. I need to write a program or develop a formula to get the data into the below format.

Data ___________________My pivot _______ Desired result

Data _ Pivot _ Final requirement

A formula or a macro. Issue I'm dealing with it converting mu columns to row and under one header which have multiple values

Upvotes: 0

Views: 36

Answers (1)

rotabor
rotabor

Reputation: 4698

Just build the pivot table by the right way:

enter image description here

Upvotes: 0

Related Questions