Pie chart- group by cell value

[Rule]

Hello,


I have multiple accounts which are billed each day with different value, it looks something like this (sorry for using Google Sheets, typing from my laptop )
Screen Shot 2019-08-14 at 10.24.22 PM.png

When I try to visualize this via pie chart I get the following result (as expected):
Screen Shot 2019-08-14 at 10.29.44 PM.png

I would like to group by the account with a similar name (in my case "ARGO") so it looks something like this:
Screen Shot 2019-08-14 at 10.30.38 PM.png

How can I do this automatically, I have 10000 of rows with the same pattern, any help is very appreciated.

Thanks a lot

[Sam Capricci]

the recommendation I would make is to make a helper column, say column C and use =LEFT(B3,SEARCH(" ",B3)*1) to pull out all the accounts without the numbers, then use that for the graph, or elsewhere you can consolidate all the information into a smaller subset to use for the chart.

[Rule]

Thank you, Sambo kid

You were right Helper column is the good way to this and bellow is my result:
11.png

I used this function

Please Login or Register  to view this content.

How can I extend this function to preserve original cell value if not match found (in my case account name) instead of #Value! ?

Thanks

[Sam Capricci]

I’m not sure, why did you change the formula from what I gave you, it would return everything up to the first space, no #VALUE.

[Rule]

Hello, your formula was very good.

However I wanted to preserve original account names (XTX 67 and ECO 5) instead of just "XTX" and "ECO".
Current formula cuts everything after the first word, and I need only "ARGO" to be summarized and others to remain intact.

Thanks for help

[Sam Capricci]

well, based on your snapshot in your first post, if you want to have exact names you can apply an IF to your formula like...
=IF(LEFT(C3,SEARCH("ARGO ",C3)*4)="ARGO ","ARGO ",B3)
untested and a guess but seems logical

[Rule]

I did try your formula but is still evaluates other accounts as #VALUE.

Attachment 637355

[Gregb11]

I can't see your attachment, but won't this work?:

Please Login or Register  to view this content.

[Rule]

I can't see your attachment, but won't this work?:

Please Login or Register  to view this content.

Brilliant, that worked indeed!
Thanks a lot