Qlik Scripting Table Issue

[#1]

I was wondering if there was a simple way to convert table 1 into table 1 new (tables in the attached spreadsheet).

Ideally by keeping the data in table 1, instead of creating a new table, as there are other data pieces in the table/rows.

Thanks,

Ben

[sunny_talwar]

May be using the The Generic Load:

Table:

Generic

LOAD Case,

    Value_Name,

    Value

FROM

[..\..\..\Downloads\example.xlsx]

(ooxml, embedded labels, table is Sheet2);