+ Reply to Thread
Results 1 to 6 of 6

Re organizing data into multiple rows from a single row with multiple columns

  1. #1
    Registered User
    Join Date
    03-04-2017
    Location
    United States
    MS-Off Ver
    2010
    Posts
    3

    Re organizing data into multiple rows from a single row with multiple columns

    I have data that looks like this

    Parameter Event_1 Event_2 Event_3
    A 0.1 0.2 0.1
    B 0.3 0.6 0.1
    C 0.5 0.7 0.1


    And, I want to make it look like this:

    Location Paramater Result
    Event_1 A 0.1
    Event_1 B 0.2
    Event_1 C 0.1
    Event_2 A 0.3
    Event_2 B 0.6
    Event_2 C 0.1
    Event_3 A 0.3
    Event_3 B 0.6
    Event_3 C 0.1

    The catch is that I have 365 parameters and 768 Events

    I've tried a number of different things, including pivots, vba, lookups, index and match but they all seem to rail or are too cumbersome. There has to be an easy way.

    Any suggestions are appreciated.

  2. #2
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,882

    Re: Re organizing data into multiple rows from a single row with multiple columns

    Try this code
    Please Login or Register  to view this content.
    < ----- Please click the little star * next to add reputation if my post helps you
    Visit Forum : From Here

  3. #3
    Registered User
    Join Date
    03-04-2017
    Location
    United States
    MS-Off Ver
    2010
    Posts
    3

    Re: Re organizing data into multiple rows from a single row with multiple columns

    Thank you! That worked
    Is there anyway to get the new table to be generated on a different sheet?

  4. #4
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,882

    Re: Re organizing data into multiple rows from a single row with multiple columns

    You're welcome.
    Change the last line to this
    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    03-04-2017
    Location
    United States
    MS-Off Ver
    2010
    Posts
    3

    Re: Re organizing data into multiple rows from a single row with multiple columns

    thank you for the addition

  6. #6
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,882

    Re: Re organizing data into multiple rows from a single row with multiple columns

    You're welcome. Glad I can offer some help for you

+ 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. Replies: 6
    Last Post: 02-19-2014, 10:25 AM
  2. Replies: 9
    Last Post: 12-15-2013, 10:05 PM
  3. Organizing Data from Multiple Columns
    By David Piggott in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-29-2013, 12:00 PM
  4. Replies: 5
    Last Post: 05-25-2013, 07:12 AM
  5. Replies: 1
    Last Post: 05-23-2012, 05:49 AM
  6. Converting grouped data in multiple rows and columns to single row
    By learner_123 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-23-2012, 05:49 AM
  7. Replies: 4
    Last Post: 05-03-2010, 07:14 AM
  8. Replies: 1
    Last Post: 03-18-2009, 04:18 PM

Tags for this Thread

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