Forum Discussion

Copper Contributor

Jan 07, 2019

Excel Help large data in inconsistent quantities

I have a data set of over 200,000 rows. It consists of certain parties (column A) and each their products (column B), however each party has a different amount of products. I need to filter out the p...

data example.xlsx6 KB

excel

Wyn Hopkins

MVP

Jan 08, 2019

Hi tommills

Attached is one approach

Note I needed to add trim since some of the Party entries had extra spaces at the end.

data example v2.xlsx12 KB

tommills

Copper Contributor

Jan 08, 2019

Hi,

Thanks for your help, just wondering what formula you used to achieve the combinations?

Thanks

Wyn Hopkins
MVP
Jan 08, 2019
Did you look at the attached file? I used & to join them
- tommills
  Copper Contributor
  Jan 08, 2019
  Oh yes I see, thank you very much