1 Reply Latest reply: Oct 9, 2014 10:36 AM by Sem Art RSS

    Excel document transformation

    Sergey Belostotsky

      Hello everyone!

       

      I have excel document:

      Example.PNG.png

      I need to transform it into:

      Output.PNG.png

       

      Any suggestions? Please help me.

        • Re: Excel document transformation

          CrossTable(Oper, Data, 3)

          LOAD Operation,

               F2,

               F3,

               [Planned maintenance],

               [Minor Repair],

               Cars,

               Buses,

               Trains,

               Repair,

               Cars1,

               Buses1,

               Trains1,

               [Major Repair],

               Cars2,

               Buses2,

               Trains2

          FROM

          [D:\Downloads\Example.xlsx]

          (ooxml, embedded labels, table is Sheet1, filters(

          Transpose(),

          Replace(1, top, StrCnd(null)),

          Replace(2, top, StrCnd(null))

          ));