I have data in following format.
Store# StoreName StoreLocation num_of_employee Total Sales Month Year
123 Chales California 55 100 01 2014
123 Chales California 75 200 02 2014
123 Chales California 100 500 04 2014
123 Chales California 44 600 06 2014
123 Chales California 22 700 08 2014
200 Delta Kansas 55 1000 01 2014
200 Delta Kansas 55 1200 02 2014
200 Delta Kansas 55 100 04 2014
200 Delta Kansas 55 1400 10 2014
200 Delta Kansas 55 2000 12 2014
............
.........
How can i transform it to this when i read it in qlikview.
Store# Discription 2014-01 2014-02 2014-03 2014-05
123 StoreName Charles Charles
123 StoreLocation California Charles
123 Num_of_employee 55 75
123 Total_sales 100 200
200 StoreName
200 StoreLocation
200 Num_of_employee
200 Total_sales
