rearranging column data with repeat instances and blank cells

Hello wise benefactor! Thank you for lending a hand. I do hope this is the right place for this question.

I have data to rearrange and output to two sheets. Data is in worksheet "raw" and output sheets are "output_1" and "output_2", respectively on attached.

First, data columns 1 to 9 are characteristics of retailers, of which I've manually selected 94 unique and copied to output_1. I want to rearrange the the grades and dates in Columns 10 and 11 to output_1. Not every date has a grade, and each retailer does not exhibit the same dates. Because "raw" columns have duplicates, I have not been able to fill in the other gaps on "output_1". I hope the layout shows more clearly what I'm trying to do.
Secondly, in output_2, I want to arrange the grade change dates and corresponding grades for each unique retailer. Can VBA do that?

Open to all ideas. Thank you again.

Try this

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Note: Output_2 is rearranged from data of output_1. So, allway run output_1 before run output_2.

Thank you so much huuthang_bd! Figuring out how you did it, and some NOOB errors on my part, prolonged this thank you message. Your solution has breathed new life into my work!

Thank you for reply. Please mark this thread as SOLVED if your problem was solved.