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!
Solved! Go to Solution.
@GroupAccountant take a look at this and see if it helps
This works, thank you very much for your prompt help, greatly appreciated!
@GroupAccountant
Glad to help