Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone!
I have excel document:
I need to transform it into:
Any suggestions? Please help me.
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))
));