Snasui Excel Forum

Hi Exceller,

I come up with a problem how to write a formula to lay out data like in color cells.
The first return entries base on value in column B vertically.
The second return entries horizontally base on value in column b too .
I also need simple formula as well


Thank you

..

D1
=IFERROR(INDEX($A:$A,AGGREGATE(15,6,INDEX(ROW($B$1:$B$4)/($B$1:$B$4>=COLUMN($A$1:$Z$1)),ROWS($D$1:D1)),COLUMNS($D1:D1))),"")



D7
=IFERROR(INDEX(A:A,AGGREGATE(15,6,ROW($B$1:$B$4)/($B$1:$B$4>=COLUMN($A$1:$Z$1)),ROWS(D$7:D7))),"")


Norkaz

Thank you