+ Reply to Thread
Results 1 to 4 of 4

Transform data with unique column

  1. 02-29-2020, 01:31 PM #1
    SHIVA_2018
    SHIVA_2018 is offline
    Registered User
    Join Date
    04-30-2018
    Location
    INDIA
    MS-Off Ver
    2013
    Posts
    33

    Transform data with unique column

    Sir,

    Excel file with two columns to be pivot with unique column like

    ACTUAL DATA
    DEPT ID
    ACCT 13910
    ACCT 13990
    ACCT 13930
    ACCT 13940
    COMM 03920
    COMM 09220
    COMM 09230
    CRM 03120
    CRM 12510
    CRM 12620
    IRM 02590
    IRM 12510
    IRM 12620
    IRM 03250


    TO BE TRANSFORMED TO

    ACCT COMM CRM IRM
    13910 09220 03120 02590
    13940 03920 12510 03250
    13950 09230 12620 12510
    13990 12620

    Sample excel file attached


    Please help
    Thank you
    Shiva
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 03-01-2020, 06:29 AM #2
    alansidman
    alansidman is offline
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,897

    Re: Transform data with unique column

    Here is a Power Query Solution. Pivot the data after adding an index column. Then remove the index column

    Please Login or Register  to view this content.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
    Reply With QuoteRegister To Reply
  3. 03-01-2020, 11:35 AM #3
    SHIVA_2018
    SHIVA_2018 is offline
    Registered User
    Join Date
    04-30-2018
    Location
    INDIA
    MS-Off Ver
    2013
    Posts
    33

    Re: Transform data with unique column

    Hii
    I tried but its not working
    the output is like

    ACCT COMM CRM IRM
    13910
    13990
    13950

    3920
    9220
    9230
    3120
    12510
    12620
    2590
    12510
    12620
    3250

    thank you
    Reply With QuoteRegister To Reply
  4. 03-01-2020, 03:25 PM #4
    alansidman
    alansidman is offline
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,897

    Re: Transform data with unique column

    Did you read the links in my signature on how to apply the code I supplied.
    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. Transform data to have a Monthly subtotal by Column
    By jp16 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 09-22-2019, 11:07 PM
  2. [SOLVED] Get&Transform/PowerQuery Unique Count Rolling 12M
    By Speshul in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 07-10-2018, 10:37 AM
  3. [SOLVED] Transform column to row. And marge some data.
    By dosi in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-10-2017, 12:55 AM
  4. transform data separated with comma into 1 column
    By royalB in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-18-2015, 09:39 AM
  5. Need Help: Transform Column to Row Data
    By inal30 in forum Excel General
    Replies: 2
    Last Post: 08-29-2013, 09:07 AM
  6. Transform 2 column table into 1 column of data
    By amiller in forum Excel General
    Replies: 8
    Last Post: 04-11-2011, 01:29 PM
  7. Transform data in column to rows
    By wisconsin262 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-16-2008, 06:38 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