Forum Discussion
Anonymous
7 years agoNot applicable
UNION from 1 crazy dataset
Hi all
here is my problem on this friday evening : i've got a weird dataset as an input
What i'd like to do is to say (in M) :
"ok column 2-3-4, you stick your a** in that table. Next : columns 4-5-6, you go under 2-3-4 etc..."
Nice output table =
col2-col3-col4
union
col5-col6-col7
union
col8-col9-col10
etc...
There are like 200 columns in that damned file !!!
one day these users will kill me :)
Thank you for your help !
- Anonymous7 years ago
hold on i think i found
don't ask me how
(basicaly with transpose/unpivot)
1 Reply
- AnonymousNot applicable
hold on i think i found
don't ask me how
(basicaly with transpose/unpivot)