Indented Headings in single column - need to extract to multiple columns

I have a spreadsheet which pulls in data, however the headings and sub-headings come in the same column i.e. A and are indented, for example:

Columns A

England
Apple
Brand A
Brand B
Pear
Brand A
Brand B
Brand C
France
Apple
Brand A
Brand B
Pear
Brand A
Brand B
Spain
Apple
Brand A
Brand B
Brand C

I need to display this in a tabular format i.e.

Country Produce Type
England Apple Brand A
England Apple Brand B
England Pear Brand A
England Pear Brand B
England Pear Brand C
France Apple Brand A
France Apple Brand B
France Pear Brand A
France Pear Brand B
Spain Apple Brand A
Spain Apple Brand B
Spain Apple Brand C

This will allow me to pivot if required. For example heading 1 is country and this is indented by 1 space, heading 2 is Produce and this is indented by 3 spaces, heading type is indented by 5 spaces.

Is there a formula I can use to keep the original indented column data but also view in a a tabular format.

Happy to send over an example Excel file.

Thanks,
Brett

I have tried Index / Match but due to the indents this is not working.