•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
Our take
If you have a spreadsheet with around 300 rows of property addresses and want to group them by suburb, there's an efficient way to achieve this without manually selecting each row. Instead of right-clicking to create a table, consider using the filter function or conditional formatting to highlight the rows containing your target suburb. This approach allows you to organize your data effectively and makes it easier to visualize the grouped information. Explore these tools to streamline your workflow and enhance data management.
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]
Read on the original site
Open the publisher's page for the full experience
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