Pull Certain Categories From List with INDEX + MATCH

Hi and welcome to the forum

index/match and vlookup normally will only return the very 1st match they find. However, try this approach to "trick" the function. In a helper column (I used F) use this, copied down...
=C3&COUNTIF($C$3:C3,C3)
(you can hide this column if you want)

Then, in your table, use this, copied down and across...
=IFERROR(INDEX(Sheet1!$B:$F,MATCH($H3&ROW(A1),Sheet1!$F:$F,0),MATCH(G$2,$B$2:$E$2,0)),"")
note, you may have to format I as currency after the copy/paste

Here's my offering...

Enter this array formula** in G3:

=IFERROR(INDEX($B:$E,SMALL(IF($C$3:$C$68="gasoline",ROW(C$3:C$68)),ROWS(G$3:G3)),COLUMNS($G3:G3)),"")

** array formulas need to be entered using the key
combination of CTRL,SHIFT,ENTER (not just ENTER).
Hold down both the CTRL key and the SHIFT key
then hit ENTER.

Copy across to J3 then down until you get blanks.

Format column G as Date.

You can make this dynamic by using a drop down list to select the category and then refer to that cell.

F2 = drop down list of categories

=IFERROR(INDEX($B:$E,SMALL(IF($C$3:$C$68=$F$2,ROW(C$3:C$68)),ROWS(G$3:G3)),COLUMNS($G3:G3)),"")

You're welcome. Thanks for the feedback!