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.