I have a report that looks like this:

Part # Order # Qty

123 5678 7
5346 3
9988 10
6665 6
7524 2297 3
6685 4
8963 4444 66
3425 44

And I need it to look like this so I can sort and use the data:

Part # Order # Qty

123 5678 7
123 5346 3
123 9988 10
123 6665 6
7524 2297 3
7524 6685 4
8963 4444 66
8963 3425 44

Is there a way to fill cells with the value from the closest cell containing
data above it?