Closed Thread
Results 1 to 3 of 3

Convert Table to List

  1. #1
    Registered User
    Join Date
    02-16-2011
    Location
    Atlanta, Georgia
    MS-Off Ver
    Excel 2003
    Posts
    10

    Smile Convert Table to List

    Hi, is there a way to convert data that looks like this table:

    Style Jan Feb Mar
    ABC 200 300 700
    DEF 900 200 600

    To become a list that looks like this:

    Style Month Units
    ABC Jan 200
    ABC Feb 300
    ABC Mar 700
    DEF Jan 900
    DEF Feb 200
    DEF Mar 600


    My data is much larger, of course, but this gives you an idea of what I am trying to accomplish. Thanks in advance!

    Amy

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2404 Win 11 Home 64 Bit
    Posts
    23,860

    Re: Convert Table to List

    Amy;
    See my response tothis duplicate post in Access Forum.

    http://www.excelforum.com/access-pro...columns-2.html

    Alan
    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

  3. #3
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Convert Table to List

    Duplicate post, thread closed.
    Entia non sunt multiplicanda sine necessitate

Closed Thread

Thread Information

Users Browsing this Thread

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

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