Excel – Transpose

Hallo Clever People,

I need to take the following data:

Object Field Low High Node
S_TABU_DIS ACTVT 1   18
S_TABU_DIS ACTVT 2   18
S_TABU_DIS ACTVT 3   18
S_TABU_DIS DICBERCLS DDDD   19
S_TABU_DIS DICBERCLS EEEE   19
S_TABU_DIS DICBERCLS AB* AE* 19
S_TABU_DIS DICBERCLS CSHE   19
S_TABU_DIS DICBERCLS AAA   19
S_TABU_DIS DICBERCLS BBBB   19
S_TABU_DIS DICBERCLS SSS   19
S_TABU_DIS DICBERCLS CSHE   19
S_TABU_DIS ACTVT 3   20
S_TABU_DIS DICBERCLS SE   21

and change it to look like this (there can be more than 20 values in DICBERCLS)

Object Field LOW HIGH NODE Low and High Combined
S_TABU_DIS ACTVT   18 1,2,3
S_TABU_DIS DICBERCLS   19 DDDD,EEEE,AB*-AE*,CSHE,AAA,BBBB,SSS, CSHE
S_TABU_DIS ACTVT   20 3
S_TABU_DIS DICBERCLS   21 SE

I’ve tried IF, but it only allows for 7 nested IFs, i have also tried a bit of VBA but that slows things down and it freezes.  🙁

 

Hoping one of you can assist, it will be greatly appreciated 🙂

By: Elna

Leave a Reply

Your email address will not be published. Required fields are marked *