In Search of a Solution that Auto Fills Cells

[stvbrown2184]

I have attached an example worksheet to display my problem.
Right now I get a spreadsheet from a supplier each week that is around 10k rows. The data in column A has to manually be dragged down until a record with different is reached. Then that record is dragged down to fill the blanks until another record is reached. Does anyone have solution for this? Right now, I have to manually drag each row down until I reach the end of a 10k row worksheet. thank you