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