How to transpose data so column A is grouped and works as a header for column b

Hello

I have about 250.000 rows of data which consist of data about cadastres (I think is the English word). I would like that my Column A which has an overall location listed (there is 1205 unique overall locations) is used as a header for all the cadastres within that area.

As far as I can understand, I might need some VBA to transpose and group my data? I tried to do a Cross-join via Access, without much luck, so I'm hoping someone here can lead me on the right track.