Copy Multiple Columns of Data from Duplicates in 1st Column into Separate Sheets

Hello,

Perhaps I am asking for the moon here, but I am trying to get the data from column B and C into a separate sheets (tabs) for each 'brand' in column A ('A' is a brand, 'B' is a brand, etc.).

- Column A has duplicates and matches the name of the sheet i want it to go into
- Column B will not have duplicates within each 'childbrandabbreviation' but will have duplicates within the column
- Column C will have duplicates, it relates to both column B and column A.

Of course v-Lookup only pulls the first match, I need all of the matches. And this can certainly be copy/pasted manually but there are 100s of brands and over 60,000 part numbers.

An example is attached...


Any help is greatly appreciated.

Thank you,
Jason

Fotis, thank you so much for your quick reply. When I open your updated file in 2003 it just shows '#NAME?' for all of the formatting, do you have any idea what I need to do?

Thanks again,
Jason

Originally Posted by Fotis1991

Hi and welcome to the forum.

If you were asking for the moon,...be sure that i could not do something for this..

But in this case, i think that i can...

Column A, will use as helper column.

In B1, of SheetA, use this Array formula.

=IFERROR(INDEX(Sheet1!$B$1:$B$19;SMALL(IF(Sheet1!$A$1:$A$19=A2;ROW(Sheet1!$A$1:$A$19));COUNTIF($A$2:A2;A2)));"")

In C1, this.

=IFERROR(INDEX(Sheet1!$C$1:$C$19;SMALL(IF(Sheet1!$A$1:$A$19=A2;ROW(Sheet1!$A$1:$A$19));COUNTIF($A$2:A2;A2)));"")

Copy down. Same way for the others Sheets.

Is this, works for you?