Results 1 to 5 of 5

From Matrix to Single List

Threaded View

gnulab From Matrix to Single List 12-01-2015, 06:27 AM
samba_ravi Re: From Matrix to Single List 12-01-2015, 06:43 AM
Richard Buttrey Re: From Matrix to Single List 12-01-2015, 06:49 AM
Glenn Kennedy Re: From Matrix to Single List 12-01-2015, 06:58 AM
FlameRetired Re: From Matrix to Single List 12-01-2015, 11:34 PM
  1. #1
    Registered User
    Join Date
    05-07-2011
    Location
    Jakarta, Indonesia
    MS-Off Ver
    Office 365
    Posts
    27

    From Matrix to Single List

    Hi Guys,

    I would like to ask for pointers how to solve this. I have a table is as follows:

    SMALL MEDIUM LARGE x-large
    design a
    design b
    design c
    design d

    Firstly, I would like to convert the products offered from matrix to single list format, that is all the various combinations in one single list: such as this.

    design a - small
    design a - medium
    design a - large
    design a - x-large
    design b - small
    design b - medium
    and so on.

    Afterwards, I would like for the value at each intersection to be copied to the corresponding entry in the single column.


    How do I accomplish this?


    Thank you!
    Henry
    Attached Files Attached Files
    Last edited by gnulab; 12-01-2015 at 10:24 AM. Reason: add file sample

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] reformatting matrix into a single column
    By fiddle in forum Excel General
    Replies: 6
    Last Post: 05-27-2014, 01:05 PM
  2. [SOLVED] How to covert lower triangle of a matrix to a single row?
    By mythili1807 in forum Excel General
    Replies: 5
    Last Post: 03-29-2013, 09:25 AM
  3. Matrix to single column
    By chris.veinot in forum Excel General
    Replies: 4
    Last Post: 07-16-2010, 09:10 AM
  4. Convert Matrix to Single Column [ROW by Row]
    By K1bb5 in forum Excel General
    Replies: 2
    Last Post: 07-09-2010, 08:55 AM
  5. Export matrix to single text
    By Kb24 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 09-05-2009, 01:27 PM
  6. Converting a matrix into a single column
    By dthan in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 11-21-2008, 05:56 PM
  7. Matrix to single column
    By RD Wirr in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 01-04-2006, 05:10 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1