• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Pivot data to convert in required format

Shabbo

Member
Dear Sir,

I have pivot table in attached format and I wanted to generate data as per “example to get data”

Eg:: company name and month wise amount .
 

Attachments

Hi Shabbo,

Just move comapy_name filed into row labels, year and month column labels in your pivot table

Dear Sir,

I have pivot table in attached format and I wanted to generate data as per “example to get data”

Eg:: company name and month wise amount .
 
Back
Top