Access MS Access Lookup problem

[ahatzvi]

Hi All

I would like to kindly request your assistance with a problem that i am having.

I have some data that i have imported into an access table. The data looks a bit like this:

Field1....... Field2
Heading1...........
............... Item1
............... Item2
Heading2...........
............... Item3
............... Item4
............... Item5
............... Item6

I need to be able to populate Field1 like this:

Field1 Field2
Heading1
Heading1 Item1
Heading1 Item2
Heading2
Heading2 Item3
Heading2 Item4
Heading2 Item5
Heading2 Item6

The file imported, will be re-imported often and is quite large.

Does anyone know of anyway this can be done via a query, or VBA function?

Many thanks