Forum Discussion
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...
I have a very large spreadsheet...I want to group...Plus I'd like to use subtotal function also to get a count of how many in each group
Another option assuming you run a Windows version of Excel >/= 2010: a Power Query + Pivot Table is attached (done w/Excel 365)
For Excel 2010/2013 the https://www.microsoft.com/en-us/download/details.aspx?id=39379 must be installed first, paying attention to select the appropriate download (32 vs 64 bit) according to the installed version of Excel