listing out different categories

say I have this data...

stock symbol...... industry

XOM oil

CVX oil

JPM banks

C banks

NVDA semiconductor

MU semiconductor

how do I make I so 3 different cells list each sector stocks.. automated title would be great

so I would want 3 columns, 2 rows

oil banks semiconductor

XOM CVX JPM C. NVDA MU

thanks in advance..... I know how to do it in long form.. but not a short form way to do it.