Results 1 to 3 of 3

Transpose array with multiple columns per 1 row

Threaded View

  1. #2
    Valued Forum Contributor AZ-XL's Avatar
    Join Date
    03-22-2013
    Location
    Azerbaijan, Baku
    MS-Off Ver
    Excel 2007
    Posts
    603

    Re: Transpose array with multiple columns per 1 row

    Hi.
    I used there helper column in data table. After that use paste this array formula to b14 cell:
    =IFERROR(INDEX($B$3:$G$10,LARGE(IF(($A$3:$A$10=$A21)*($H$3:$H$10=COUNTIF($B$20:B$20,B$20)),ROW($A$3:$A$10)-2,""),1),MATCH(B$20,$B$2:$G$2,0)),"") CSE

    Uploading file.here. Didnt touch your outcime table. Created my own below it
    Attached Files Attached Files
    Appreciate the help? CLICK *

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