Forum Discussion
lfk73
Jun 17, 2021Brass Contributor
Group rows based on similar text
I have a very large spreadsheet with one column that start with similar text but pretty much every line is slightly different. Below is a rough idea on what I mean (image two columns): ID Softw...
Riny_van_Eekelen
Jun 17, 2021Platinum Contributor
lfk73 The three words in your post "very large spreadsheet" would warrant to look into Power Query as a variant to the formula based solution with sub-totals as suggested by HansVogelaar
But since your example give only a "rough idea" of your real data, I might be wrong.