Re-arrange data from vertical to horizontal

Another non-array way. This works as long as your Products are contiguously grouped as you have them in column A.

Copy / paste this into G3, fill down and across until you get blanks.

Formula:

=IFERROR(INDEX(INDEX($B$3:$B$18,MATCH($F3,$A$3:$A$18,0)):INDEX($B$3:$B$18,MATCH($F3,$A$3:$A$18,1)),COLUMNS($A:A)),"")

The file is attached.