+ Reply to Thread
Results 1 to 6 of 6

Values from matrix to column

  1. #1
    Registered User
    Join Date
    02-13-2017
    Location
    Sofia
    MS-Off Ver
    2016
    Posts
    4

    Values from matrix to column

    Hello, is it possible transfer values from matrix to column with formula
    In matrix,in first are stores and in column are articles and is defined rules for sales with Y and N.
    How to transfer this values Y and N in column where every article is combined with every store?
    Atached file is exmple table

    Thank you in advance
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Excel 2016
    Posts
    13,764

    Re: Values from matrix to column

    I used power query the sheet Oeldere.

    See the file if this is the result you like?
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  3. #3
    Forum Expert
    Join Date
    11-28-2012
    Location
    Guatemala
    MS-Off Ver
    Excel 2010
    Posts
    2,394

    Re: Values from matrix to column

    try this macro. It has been tested with the given data.
    Please Login or Register  to view this content.

  4. #4
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... based in Ireland
    MS-Off Ver
    µSoft Office 365. Learning Excel all over again!!
    Posts
    30,958

    Re: Values from matrix to column

    ...or using a good ol' formula:

    =INDEX(DeliveryRules!$B$2:$U$21,MATCH(Products!B2,DeliveryRules!$A$2:$A$21,0),MATCH(Products!C2,DeliveryRules!$B$1:$U$1,0))

    coipied down.
    Glenn



  5. #5
    Registered User
    Join Date
    02-13-2017
    Location
    Sofia
    MS-Off Ver
    2016
    Posts
    4

    Re: Values from matrix to column

    Thank you very much for your help

  6. #6
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Excel 2016
    Posts
    13,764

    Re: Values from matrix to column

    @iwian

    It is always good to refer to whom you are replying.

+ 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: 1
    Last Post: 12-28-2015, 08:43 AM
  2. Replies: 2
    Last Post: 11-05-2014, 03:41 AM
  3. Matrix: Identify cell content in column for a row if matrix content true
    By deuy2014 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-21-2014, 11:52 AM
  4. Replies: 2
    Last Post: 12-27-2013, 01:12 PM
  5. Replies: 0
    Last Post: 01-24-2013, 02:10 PM
  6. Select a Date between Two Date Rows, then the Column State and return Table Matrix Values
    By InNeedofHelpASAP in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-12-2012, 11:03 AM
  7. converting "matrix" of values into single column
    By suszak in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-28-2007, 11:22 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1