How to i am use my excel sheet column data in row wise because qlikview are only read data row wise...
You can transform the data using qv wizard. Learn about crosstable() as well.
You can use the concept of cross table. Can you share your workbook so that we can take a look into it?
Please share your excel file for better understanding.
Crosstable prefix to a LOAD statement generates new rows per column with at least one common column as first columns.
hope this helps
Retrieving data ...