Transpose/ Cross Table in Excel Binary WorkBook Format to EXCEL - Scripting Issue

[lakshmanvepuri]

HI All,

@sunny_talwar 

Need Help in LOAD Issue Issue, I have update the requirement in the excel binary workbook.

1 . Need to load data from ROW 7 on wards. ( Delete the Previous Rows )

 

1Q19 BASE Qty should be taken 1Q19  -- BASE QTY --- Value

2. Transpose as given below with splitting as below.

3. Data is volume is high and is not limited...( Columns and ROWS are More)

4. Enclosing the Requirement Excel Binary WorkSheet. Please help on the scenario ( Enclosed in ZIP Format )

Thanks in Advance,

LK Vepuri

[lakshmanvepuri]

Hi all,

please help me on this.. I am struck up here .. 

Thanks a lot

LK vepuri

[Saravanan_Desingh · Accepted solution]

Hi, Please see my solution which is similar to your requirement. Try this out. Otherwise let me know.

https://community.qlik.com/t5/QlikView-Scripting/CrossTable-Transpose-Rotate/td-p/1555627