Organising complicated multiple column data into row data

Hi @Wei_Ji_Kwok ,

Could you Provide us with the Sample Input data and the Expected Output data in the form of Excel files ?

We could avoid confusions of the logic that needs to be devised and suggest/provide you with the appropriate approach.