DataSource Controls :: Do I Need A Cursor For This

Running a select * from my table give me data like this:

Field1 Field2 Field3 Field4 Field5 Field6

NULL NULL NULL J 4GG4K C46D

DRIVE 0155 1 NULL W6665 NULL (C46D)

TEST 01444 5 NULL W4434 NULL (C46D)

NULL NULL NULL 1 WGG4K AAVE

HOME 01444 3 NULL 5HTYL NULL (AAVE)

NEW 09888 9 NULL 8HTTTE NULL (AAVE)

The problem is Field6 for the rows that are bolded. I need Field6 to repeat for each row until the next non null value is found in Field6, than I need that value to repeat again. I placed in parenthesis outside the NULL for Field6 what I need to show which is the value of Field6 above the records which Field6 is null.

I know this is confusing, but it's actually pretty simple to understand. I just need to get the first NON NULL value of Field6 and UPDATE the records below it where Field6 IS NULL to that value, then when it reached the next bolded row there is a new value for Field6, I then need to get that value and UPDATE the records below it which are null with the value.