sql - The equivalent of dragging in Excel but in an Access query -

i have rather large file, big excel stuck access , has format this:

id     type    amount 1234         500        b       750        c       589 5678         200        f       9000 9101   h       44 

my issue id field represented once during grouping yet there can multiple rows associated it. there way using sql drag down id field blank values?

if file big excel then, mentioned, you'll need break chunks.

in excel can fill blanks id above follows:

• select column, or data (including blanks) in column
• choose home tab, find & select group, go special (or ctrl-g, click special..)
• select blanks , press ok; select blank cells in range
• type = , press arrow on keyboard select whichever cell above active cell
• press ctrl-enter fill same formula in empty cells
• highlight column again , copy, right-click paste-special, values.

it near easy in access. firstly need create artificial, number-sequence column (in excel) remember original order. quite complicated sequence of queries needed. entirely in excel if @ possible.