Cross table from Vertical to Horizontal from Load Editor

[AN2024]

Hello,

I have this table (below) and I need to convert from vertical to horizontal from Load Editor

Month-Year | Count of Providers

JAN-20 | 15

FEB-20 | 30

MAR-20 | 45

APR-20 | 60

I need to show the data of this way:

Provider | JAN-20 | FEB-20 | MAR-20 | APR-20
Provider | 15        | 30           | 45         | 60

Any of you have any suggestion to solve this situation?

I appreciate your help.

[Kushal_Chawda]

@AN2024  Create Pivot table with Column Dimension MonthYear and Measure as Count(Provider)

[AN2024]

Thank you for your answer, I forgot to mentione I need to achive that using only the load editor

[MatheusC · Accepted solution]

The solution in this post may help

https://community.qlik.com/t5/New-to-Qlik-Analytics/cross-table-in-Qlik-Sense/td-p/1295974

- Regards, Matheus