Moving dividing table titles in excel file into new column

[davidnolan]

Hello,

I have an excel file that groups data into mini tables with a header (e.g. interest income, dividend income, etc.) and I am trying to create a column that will have the headings next to the data instead. See screenshots below. I would like the highlighted "table titles" to be moved into a column next to its data to allow for easy filtering. I have attached an excel of sample data below also. In reality my file is much larger than the extract and there is no definitive list as to what the headers may be. Any help would be massively appreciated!

Thanks!

Existing Layout

Desired Layout

[Christina_H · Accepted solution]

Multi-row formula is what you need here

[davidnolan]

Thank you very much, exactly what I was looking for!