Hello, first time poster here so hope I have done it correctly....
I work in a lab and we have an old system that generates data in the format in the attached file where it can only generate 4 rows and after this it makes another column.
Book1.xlsx
Is there an easy way to group the headings together using a formula or option so it looks like the below?
Book2.xlsx
Thank you in advance
Bookmarks