1 min readfrom 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.

submitted by /u/Boom_Gate_Lady
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#rows.com