Cross tab

[#1]

anyone have idea how to convert my expression in to row and dimension into columns like this

[ali_hijazi]

first load data as is

T1:

load * from ....

then

crosstable(Month,MonthName,4) load * resident your table

[SunilChauhan]

you could use pivot table and drag column(Month) from verticle to horizontal

or

Crosstable(Month,Data,3)

Load Company,

Product,

*

from path

and then calculate expressions

[sujeetsingh]

The options suggested above  for script level and are correct.

Whereas you can try Pivot table in UI and make the dimension  as columns