Excel Formula assist

Brass Contributor

Dears,

Could you please assist regarding the attached sample, as i want to horisontaly the data according to the parent code as i mentioned in target.

 

Thanks you for your usual support

3 Replies

@HansVogelaar Could you please assist regarding that. and thanks for your usual assist 

 

@Hussein_Mohamed 

I think there may be some confusion as to what's expected for the desired results.  The codes are unique but a given code is shown 3x in the desired results:

Patrick2788_0-1696275283292.png

 

Shall all codes be shown 3x each in the desired results? Additionally, it appears the 3rd stack in blue shows multiple codes whereas the first two stacks repeated a given code 3x.

 

@Patrick2788 

Sorry for the confusion. i think the below table explain more (am just to trying to seperate the codes to be parents and sub through levels according to the combination code)

Hussein_Mohamed_0-1696277114002.png