Forum Discussion
Changing row/column orientation (?)
Ok, I'm not sure how to word this... I have a huge list of items that all have several ROWS each. Each row of information for the products varies only by quantities and price. Example...this...
=IFERROR(INDEX($B$3:$B$21,SMALL(IF($A$3:$A$21=$E3,ROW($1:$19)),COLUMN(A1))),"")
=IFERROR(INDEX($C$3:$C$21,SMALL(IF($A$3:$A$21=$E3,ROW($1:$19)),COLUMN(A1))),"")
These formulas could be an alternative solution. Enter formulas as matrixformulas with ctrl+shift+enter if you don't work with Office365 or 2021. The unique list of items can be created with data -> remove duplicates.