Using transpose or other way to make a table

What is your expected answer in C, D, E & F for this combination:

PLSTR1177 GREEN

First part. Insert an extra row on the 2nd sheet. In A3, copied across to B3 and down:

=IFERROR(INDEX(Export!B:B,AGGREGATE(15,6,ROW(Export!$B$2:$B$1555)/(COUNTIFS($A$1:$A2,Export!$B$2:$B$1555,$B$1:$B2,Export!$C$2:$C$1555)=0),1)),"")

In the absence of an answer... I have made a guess.

I also made a mistake in my first formula. No need for an extra row. I have no idea where I got that idea from...


In B2, copied across and down:
=IFERROR(INDEX(Export!B:B,AGGREGATE(15,6,ROW(Export!$B$2:$B$1555)/(COUNTIFS($A$1:$A1,Export!$B$2:$B$1555,$B$1:$B1,Export!$C$2:$C$1555)=0),1)),"")

In C1, copied across to Z1:
=IFERROR(INDEX(Export!$D$2:$D$1555,MATCH(0,INDEX(COUNTIF($B$1:B$1,Export!$D$2:$D$1555),0),0)),"")

In C2, copied across and dnown:
=IFERROR(INDEX(Export!$E$2:$E$1555,MATCH(1,INDEX((Export!$B$2:$B$1555=$A2)*(Export!$C$2:$C$1555=$B2)*(Export!$D$2:$D$1555=C$1),0),0)),"")

It's a wee bit slow (cols A & B are tough going for the PC).

Providing you don't make a mistake, yes!! But isn't the easiest thing to create a template sheet with the calculations there and padste your daily data into it?