Transposing a field values as columns

[#1]

Hello,

I have my data set as the below. Importing this table from SQL database.

I want to transpose the KPI field to columns like the below.

I tried generic load and concatenating, but its taking so much time to load the script and gets struck after a point of time.   Are there any better ways to do it ?

Thanks for your help !

[giakoum]

crosstable function

[vishsaggi]

Load the data and use Pivot table.

Add Dim: Month and KPI

Add Expr: Sum(Value)

Then transform KPI by dragging on top of the expression value.