Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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 !

  • Anonymous's avatar
    Anonymous
    7 years ago

    hold on i think i found

     

    don't ask me how

    (basicaly with transpose/unpivot)

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    hold on i think i found

     

    don't ask me how

    (basicaly with transpose/unpivot)