Help Please!

%3CLINGO-SUB%20id%3D%22lingo-sub-1870632%22%20slang%3D%22en-US%22%3EHelp%20Please!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1870632%22%20slang%3D%22en-US%22%3EI%20have%20multiple%20tables%20of%20'core'%20data.%3CBR%20%2F%3E%3CBR%20%2F%3EAnd%20multiple%20tables%20of%20custom%20configured%20data%20(based%20on%20custom%20combinations%20of%20the%20core%20data).%3CBR%20%2F%3E%3CBR%20%2F%3EBoth%20the%20above%20are%20on%20Sheet1.%3CBR%20%2F%3E%3CBR%20%2F%3EI%20then%20have%20Sheet%202.%3CBR%20%2F%3ESheet%202%20is%20one%20large%20spreadsheet%20that%20needs%20to%20pull%20data%20from%20both%20the%20core%20data%20and%20custom%20configured%20data%20tables.%3CBR%20%2F%3EIn%20one%20particular%20instance%2C%20I%20need%20to%20pull%20across%20multiple%20rows%20that%20relate%20to%20data%20in%20one%20cell%2Fone%20column%20(eg%20Column%20A%2C%20Cell%201%20reads%20%3D%20Tub%20A1.%20Tub%20A1%2C%20in%20this%20custom%20configuration%2C%20holds%205%20Bins.%20The%20Bin%20data%20is%20reflected%20in%20Columns%20B%2C%20C%2C%20D%2C%20E%20and%20rows%201-5).%20So%20-%20when%20A1%20is%20referenced%20on%20the%20spreadsheet%20on%20Sheet2%2C%20I%20need%20it%20to%20recognise%20that%205%20rows%20of%20data%20need%20to%20come%20across%20from%20the%20table%20on%20Sheet%201%20and%20the%20data%20in%20the%20columns%20within%20those%20rows%2C%20need%20to%20sit%20in%20specific%20columns%20on%20the%20spreadsheet%2C%20not%20necessarily%20in%20the%20exact%20order%20that%20they%20sit%20within%20the%20table.%3CBR%20%2F%3E%3CBR%20%2F%3EHelp%20please!%20Someone....%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1870632%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1871451%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20Please!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1871451%22%20slang%3D%22en-US%22%3EHi.%3CBR%20%2F%3EIt%20is%20not%20crystal%20clear%20what%20you%20want%20to%20do.%20Does%20this%20feel%20like%20a%20relevant%20starting%20point%3F%20Or%20do%20I%20misunderstand%20you%20completely%3CBR%20%2F%3E%3D%20TRANSPOSE(FILTER(Sheet1!B%3AB%2CA2%3DSheet1!A%3AA))%3C%2FLINGO-BODY%3E
Occasional Visitor
I have multiple tables of 'core' data.

And multiple tables of custom configured data (based on custom combinations of the core data).

Both the above are on Sheet1.

I then have Sheet 2.
Sheet 2 is one large spreadsheet that needs to pull data from both the core data and custom configured data tables.
In one particular instance, I need to pull across multiple rows that relate to data in one cell/one column (eg Column A, Cell 1 reads = Tub A1. Tub A1, in this custom configuration, holds 5 Bins. The Bin data is reflected in Columns B, C, D, E and rows 1-5). So - when A1 is referenced on the spreadsheet on Sheet2, I need it to recognise that 5 rows of data need to come across from the table on Sheet 1 and the data in the columns within those rows, need to sit in specific columns on the spreadsheet, not necessarily in the exact order that they sit within the table.

Help please! Someone....
2 Replies
Hi.
It is not crystal clear what you want to do. Does this feel like a relevant starting point? Or do I misunderstand you completely
= TRANSPOSE(FILTER(Sheet1!B:B,A2=Sheet1!A:A))

I see now that you have several columns. Something like this might work

 

=LET(mtx,FILTER(Sheet1!B:E,A2=Sheet1!A:A),
rCount,ROWS(mtx),
cCount,COLUMNS(mtx),
mCount,rCount*cCount,
INDEX(mtx,QUOTIENT(SEQUENCE(,mCount),rCount)+1,MOD(SEQUENCE(,mCount,0),cCount)+1))

(make one row if you prefer that)