+ Reply to Thread
Results 1 to 2 of 2

Expanding/unsummarizing a table by giving a separate row to a value in one column

  1. 12-10-2019, 10:16 PM #1
    Ballet4ever
    Ballet4ever is offline
    Registered User
    Join Date
    04-25-2019
    Location
    canada
    MS-Off Ver
    365
    Posts
    45

    Expanding/unsummarizing a table by giving a separate row to a value in one column

    Hello,
    Is it possible to transform a table by giving a separate row to the value in Q-ty column, like below:

    Unsummarize.JPG
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 12-11-2019, 02:16 AM #2
    Sadath31
    Sadath31 is offline
    Valued Forum Contributor Sadath31's Avatar
    Join Date
    03-02-2011
    Location
    Dammam, Saudi Arabia
    MS-Off Ver
    Office 365
    Posts
    452

    Re: Expanding/unsummarizing a table by giving a separate row to a value in one column

    Hi

    You can do it with Power Query... Here is the code

    HTML Code: 
    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. [SOLVED] Calling Two Modules to create separate pivot tables giving Run-Time Error 1004
    By cornisnice in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-02-2019, 06:20 PM
  2. Extract data from a table into separate column
    By BRISBANEBOB in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 08-06-2018, 06:34 AM
  3. [SOLVED] Extract Information from a column to make a separate table
    By kaleonard08 in forum Excel General
    Replies: 5
    Last Post: 03-21-2016, 02:41 PM
  4. Convert Expanding Table into Single Column
    By markmkramer in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-29-2014, 08:03 PM
  5. Separate column in pivot table
    By MODY in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-21-2007, 02:39 AM
  6. Append data from a column to separate table array
    By miss_q in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-12-2005, 07:01 PM
  7. [SOLVED] Can Row and Column Inputs in 2 Var. Data Table be on a separate sh
    By RED in forum Excel General
    Replies: 0
    Last Post: 05-03-2005, 11:06 AM

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