Excel Formula assist
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
Forum Discussion
HansVogelaar Could you please assist regarding that. and thanks for your usual assist
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:
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.
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)