May 27, 2026•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

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.

Check out the full article on the original site

#rows.com

#Excel alternatives for data analysis

#big data management in spreadsheets

#generative AI for data analysis

#conversational data analysis

#automated anomaly detection

#Excel compatibility

#real-time data collaboration

#intelligent data visualization

#data visualization tools

#enterprise data management

#big data performance

#Excel alternatives

#data analysis tools

#data cleaning solutions

#stock symbol

#industry

#oil

#banks

#semiconductor