Excel file format.

[#1]

Hi I have attached an  excel file,In sheet 1 I have the original format and I want to convert that to the format as in sheet 2 in qlikview.

Can this be done ?

Thanks much.

[sunny_talwar · Accepted solution]

You can fix the data in the backend and see the way you want using a pivot table:

[vishsaggi]

May be like this?