Hello,
I have read your description and downloaded the attachment. However, I need to know how you want the rows split. Is it somethng like below ?(Column D to J)
MB18 MB18 - - MB15
- - MB18U MB18U MB15
An example would make me understand better.
Whatever rule you want to follow in soplitting up the data I think I can help you out there. I'll write VBA codes that will examine each cells of data in each row, and based on the rule provided, it shall make a new row (s) from the data. No matter how many rows are there.
Please feel free to message me if you need further clarifications
With thanks & best regards
Raad