Moving duplicate entries to their own sheet

[Jordan155]

Hello,

I was hoping someone could help me I have gotten stuck trying to solve an issue I am having. I currently have a sheet of 20,000+ items and 2 columns. My first column is an part number and the second is a date. Each part number can be show multiple times but will have a different date each time. What I want to do is that the first occurrence of each part number (and corresponding date) and put it in sheet 1, the second occurrence of each part number and date into cell 2, third in cell 3 and so on... not all part numbers are showing multiple times, only certain ones.

Does anyone have any suggestions for this?

Any help would be great.

THANKS

[oeldere]

You can use a pivot table to get those date.

Since you don't add an excel file, without confidential information, I can't show it to you.

I'm interested why you want to store it that way.