Combining similar names in a column issue

[datadelta]

I'm not sure how I can easily solve this without correcting with a extensive formula in Excel but, I'm pulling in data from SQL and some of the names pulled in are the same but different.

I have names coming in like, Bobs Surplus Store then Bobs Surplus Store LLC, Bob's Surplus Store LLC, inc.

How do I get these combined under just Bobs Surplus Store?

thanks!

[rubayatyasmin]

Hi, @datadelta 

how about grouping? 

Group In Excel - How To Group/Ungroup Data? (Easy Steps) (wallstreetmojo.com)

[datadelta]

Thank you.  Yes, I know how to solve in Excel but my issue is that I want to set up an intake rule in BI to always compbine the incoming SQL data as it updates.

Thanks for the reply and possible solution!

[rubayatyasmin · Accepted solution]

try using group by in power query. 

here is the documentation.

https://learn.microsoft.com/en-us/power-query/group-by