I have data in 3 columns: A, B & C
Column A contains the whole data, Column B contains Seperation 1 & Column D onward contains compilation as per language.
Please see attached sheet.
I have the values populated in B & C, this is what I am looking to resolve:
When there is a value in Column B they should be separated from column E - I (there are always 5 values)
Next, till the next value is reached in column C, the rows in column A should be concatenated & put from column E to I deepening upon the heading
Please let me know if something is not clear, I have tried to make it as descriptive in the file.
Regards & Thanks,