Excel document transformation

Thu, 09 Oct 2014 14:21:26 GMT

Hello everyone!

I have excel document:

I need to transform it into:

Any suggestions? Please help me.

Re: Excel document transformation

Thu, 09 Oct 2014 14:36:40 GMT

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

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

Transpose(),

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

Replace(2, top, StrCnd(null))

));