+ Reply to Thread
Results 1 to 4 of 4

Turn data set into a table for pivot table

  1. 02-12-2024, 05:12 AM #1
    NicBKK
    NicBKK is offline
    Registered User
    Join Date
    08-08-2018
    Location
    Bangkok
    MS-Off Ver
    MS365 for Mac (latest version)
    Posts
    96

    Turn data set into a table for pivot table

    Hi Gurus,

    I receive a report from a lot of my factories with their sales by product in a set format

    Is there a way to have a formula to create an easy table for pivot table purposes?

    Excel attached

    SCR-20240212-ofzw.png
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 02-12-2024, 05:26 AM #2
    ben8563
    ben8563 is offline
    Forum Contributor
    Join Date
    03-28-2021
    Location
    China
    MS-Off Ver
    O365
    Posts
    111

    Re: Turn data set into a table for pivot table

    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  3. 02-13-2024, 09:51 AM #3
    HansDouwe
    HansDouwe is offline
    Forum Guru HansDouwe's Avatar
    Join Date
    06-21-2022
    Location
    Nederland
    MS-Off Ver
    365 V2403 (Build 17330.20000)
    Posts
    6,466

    Re: Turn data set into a table for pivot table

    Another formula:
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  4. 02-14-2024, 01:36 AM #4
    Czeslaw
    Czeslaw is offline
    Forum Expert
    Join Date
    12-09-2014
    Location
    Trakai, Lithuania
    MS-Off Ver
    2016
    Posts
    1,418

    Re: Turn data set into a table for pivot table

    Power Query
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Table to column problem to create dataset for pivot table [Bloomberg data to pivot table]
    By fajfus in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 01-24-2017, 06:56 PM
  2. [SOLVED] How To Turn Two-Way Data Table Into Pivot Table
    By zanshin777 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 09-18-2015, 04:46 AM
  3. [SOLVED] VBA code to turn data into pivot table and then into pivot chart
    By Faintkitara in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-25-2015, 09:05 PM
  4. Programme to turn downloaded data into a form that's recognised by pivot table
    By suesein in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-23-2014, 03:49 AM
  5. How to turn off Pivot Table subtotaling and other edits
    By riwiseuse in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-20-2010, 04:20 AM
  6. How do you turn off pivot table auto format in Excel?
    By srudd in forum Excel General
    Replies: 3
    Last Post: 11-30-2005, 12:40 AM
  7. [SOLVED] Pivot Table - 3 columns turn-around-times
    By William Elerding in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-12-2005, 04:05 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1