I have a spreadsheet with over 6,000 records. it is setup as follows:

A1:E1 are the column headings
A1= CustomerID; B1= Customer; C1=Item; D1= Item Description; E1= Price


Rows 1-5 have Customer ID & Customer informaion
Rows 6-15 is the order information for Customer in Row 5 but the column information for column A6:B15 are blank

I want to automatically fill in the values in row A6:B15 with the first non-blank information from above. In this case it would be A5:B5.

This needs to be done by finding the blank cells since there is no pattern to the information and there are too many blanks to go through and manually edit the information and some blanks are only one row and others are multiple rows.

Thanks for the help!
Steve M.