Try something like this:

With your data list in A1:D7 (including column headings)

F1: Product No
G1: Info_1
H1: Info_2
I1: Info_3

This ARRAY FORMULA* will list each unique Product No
F2:
=IF(SUMPRODUCT(($A$2:$A$11<>"")*ISERROR(MATCH($A$2:$A$11,$F$1:F1,0)))<>0,INDEX($A$2:$A$11,MATCH(TRUE,ISERROR(IF(ISBLANK($A$2:$A$11),FALSE,MATCH($A$2:$A$11,$F$1:$F1,0))),0),1),"")

Note: For array formulas, hold down [Ctrl] and [Shift] when you press
[Enter], instead of just pressing [Enter].

Copy that formula in to F3 and down as far as you need

This regular formula will combine and list the component data
G2:
=INDEX($A$2:$D$11,SUMPRODUCT(MATCH($F2&"_"&COLUMNS($F2:F2),$A$2:$A$11&"_"&$B$2:$B$11,0)),3)&"
"&INDEX($A$2:$D$11,SUMPRODUCT(MATCH($F2&"_"&COLUMNS($F2:F2),$A$2:$A$11&"_"&$B$2:$B$11,0)),4)

Copy that formula across and down as far as you need

Note: Since text wrap will impact the display, those formulas contain NO
spaces.

I know it's not elegant, but is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP