Repeating header into new column based on format

[GroupAccountant]

Hi,

I have been trying to use the multi-row formula to perform the below action on a data set whereby in one column there is a various types of data including multiple headings. Is there a way i can copy & paste the heading in front of each row below and for the heading to change when it gets to a new format in the data e.g. from "\w{2}-\d{1}-\w{1}" to "\w{2}-\d{1}"?

From the left data to produce the data on the right:

 

Thank you in advance for any help, greatly appreciated! 

[aatalai · Accepted solution]

@GroupAccountant take a look at this and see if it helps

[Qiu · Accepted solution]

@GroupAccountant 

We can use Multi-Row Formula tool for this as below.

[CPSlater]

Think this may work.

[GroupAccountant]

This works, thank you very much for your prompt help, greatly appreciated! 

[Qiu]

@GroupAccountant 
Glad to help