for example I have a table named TBLtest. This table has 3 fields. PlateNo, TicketNo and Type. It is imported as

578bzz 123778 T
F
626bss 128000 T
677ghg 233339 T
865jht 244008 T
F
P

Where ever there is a blank it must update the table to display the previous plateno and ticketno. so the new table should look like this

578bzz 123778 T
578bzz 123778 F
626bss 128000 T
677ghg 233339 T
865jht 244008 T
865jht 244008 F
865jht 244008 P

Please help