Say your results table is in a sheet called "Results", with column headers starting at A2 and figures below.
Add a "helper" formula in column F at F3,
=A3&"_"&COUNTIF(A$3:A3,A3)
copied down as far as you want in order to capture future data. (You can hide this column)
Now in the sheet for Item A, beginning at A2 enter formula:
=IFERROR(INDEX(Results!B:B,MATCH("A"&"_"&ROWS($A$2 :$A2),Results!$F:$F,0)),"")
copied across 4 columns and down as far as you want to capture future data.
Repeat for other items replacing the "A" with the corresponding Item.
Now when you type new row in Results sheet, it would populate in next row of corresponding item.
|