Help with formula to copy headings

I have an export from my accounting software for all my transactions for the year. Each account will have a heading with the unique account number and then all the accounts will then show below. I want a formula that will copy the heading to a column in each row. I don't want to do it manually as it is thousands of lines.