• 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.

Structure complicated raw data into Pivot

S

SSJ

New Member
Hey everybody,

I have been struggling with the attached file to turn it into a structure for Pivot and I have to present my findings tomorrow for my boss. I want to turn it in to pivot data. can you please help me??? these are sales by store by month and bu category.
 

Attachments

This data *appears* as if it is coming from a ERP/Database/External source and is "formatted" for Excel - however, it is intended to be printed in Excel, not really analyzed. Your issue is to connect your source data to Excel in a different manner so that you can use its power to help you with analysis.

There are several ways of doing this, some are better than others, and it depends on how you want to approach the challenge.
  • You can link the external data directly to PowerPivot (but you'll need at least Excel 2010, preferably 2013)
  • You can use PowerQuery to access a CSV file from the External data.
  • You can import a CSV file from the external data into an Excel Worksheet.
  • etc.
Do you have much control over the external data, and how to link to it?
 
You must log in or register to reply here.
Back
Top