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'd create a helper column:
The formula in C2 is
=TRIM(LEFT(SUBSTITUTE(B2," ",REPT(" ",255),2),255))Then click in the table and select Subtotal on the Data tab of the ribbon.
Specify that you want to add a subtotal at each change of Group (the helper column) use Count as summary function, and add the subtotal to the Group column. Then click OK.
Result: