row into colomns

[#1]

LOAD Date(Date,'DD/MM/YYY') As Date,
Dimension,
TxnType,
WOS as Distribution,
[Seller HQFlag] AS [Outlet Type]
// Region,
// ModelCode
FROM

(qvd);
//Left Join

Meess_Temp1:
LOAD
Date(Date,'DD/MM/YYY') As Date,
Dimension,
TxnType,
WOS as Distribution,
[Outlet Type]

// Region,
// ModelCode
FROM

(qvd);

i have input like below i attached .i want to get

Out letType  D-2  Wk-1  Wk-2

Distribution  4.9   4.8      4.7

like this i want output.

the implementation must be done in scripting side ony.

plz help me

[robert_mika]

Try Cross Table or generic load.

Your Word file can not be opened..