Pl see attached file.
A38:A44 is A,B,C,D,E,F,G
ARRAY formula in B38, then dragged across.
=IFERROR(IF(MOD((COLUMNS($B$37:B$37)-1),3)=0,TEXT(INDEX($B$2:$D$25,SMALL(IF(($A$2:$A$25=$A38)*($A$2:$A$25<>""),ROW($A$2:$A$25),""),INT((COLUMNS($B$37:B$37)+2)/3))-ROW($A$2)+1,1+MOD((COLUMNS($B$37:B$37)-1),3)),"mm-dd-yyyy"),INDEX($B$2:$D$25,SMALL(IF(($A$2:$A$25=$A38)*($A$2:$A$25<>""),ROW($A$2:$A$25),""),INT((COLUMNS($B$37:B$37)+2)/3))-ROW($A$2)+1,1+MOD((COLUMNS($B$37:B$37)-1),3))),"")
ARRAY formula is used
To enter ARRAY formula
Paste the formula
Press F2
Press Ctrl+Shift+Enter keys together.
formula will be covered with{} brackets by excel.
Bookmarks