•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Group particular rows that contain certain words
I have a about 300 rows of data in a spreadsheet, I want to select all the rows that contain a certain word and group them somehow or put them in a table.
When I control, select the rows manually and right click the option to create a table disappears.
There must be a way I can do this. Does anyone have any ideas?
For context, the list is property addresses and I want to group them by suburb.
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#rows.com
#Excel alternatives for data analysis
#generative AI for data analysis
#natural language processing for spreadsheets
#big data management in spreadsheets
#modern spreadsheet innovations
#machine learning in spreadsheet applications
#enterprise-level spreadsheet solutions
#digital transformation in spreadsheet software
#conversational data analysis
#Excel compatibility
#collaborative spreadsheet tools
#AI-driven spreadsheet solutions
#cloud-based spreadsheet applications
#real-time data collaboration
#automation in spreadsheet workflows
#intelligent data visualization
#no-code spreadsheet solutions
#AI-powered spreadsheet
#data visualization tools