I have a table like this with over 100 rows (different times contains in column 7).
In my example I have 2 times BOB and 3 times EVA but eva or different name can be 10times(10rows with EVA) in there.
COLUMN1 COLUMN2 COLUMN3 COLUMN4 COLUMN5 COLUMN6 COLUMN7 DOG TAP KAP 28 7 672 BOB MOUSE XY XY XY 16 672 BOB DOG TAP KAP 6 5 525 EVA MOUSE XY XY XY 2 525 EVA CAT ZY XY XY 1 525 EVA
I expect result like this:
COLUMN1 COLUMN2 COLUMN3 COLUMN4 COLUMN5 COLUMN6 COLUMN7 COLUMN8 COLUMN9 COLUMN10 COLUMN11 COLUMN12 COLUMN13 COLUMN14 COLUMN15 COLUMN16 COLUMN 17 DOG TAP KAP 28 7 MOUSE XY XY XY 16 NULL NULL NULL NULL NULL 672 BOB DOG TAP KAP 6 5 MOUSE XY XY XY 2 CAT ZY XY XY 1 525 EVA
I tried transponate in Excel like so:
=when(long(A2) > 0, A2, E1)
even I can do in Excel.
Thanks for opinions