+ Reply to Thread
Results 1 to 2 of 2

How to normalize data for pivot table.

  1. #1
    Forum Contributor
    Join Date
    08-14-2013
    Location
    LA Baby!!
    MS-Off Ver
    Excel 2007
    Posts
    1,598

    How to normalize data for pivot table.

    Hello. I have a spreadsheet with thousands of rows for different product and I have four categories on the columns. Each of the categories has a year (1-7). I would like to transform this information so that I could use it in a powerpoint. I've attached a sample. Keep in mind that in the original there are thousands of rows. I tried doing pivottable wizard, multiple consolidation ranges, and then double clicking totals but that only seems to work for one variable. Thanks!!
    Attached Files Attached Files

  2. #2
    Forum Expert Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,284

    Re: How to normalize data for pivot table.

    Try this:
    Please Login or Register  to view this content.
    let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source

    If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE

    Walking the tightrope between genius and eejit...

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Macro to Normalize Data
    By Brawnystaff in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-22-2014, 09:49 PM
  2. Normalize data
    By MrKickAss in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-17-2014, 12:13 PM
  3. How to normalize data
    By excellicious in forum Excel General
    Replies: 3
    Last Post: 02-05-2009, 11:20 PM
  4. VB Macro to normalize a table
    By hasardeux in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-20-2009, 08:24 AM
  5. problem to normalize data
    By alnnbutms in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-19-2006, 07:40 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1