Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
May be using the The Generic Load:
Table:
Generic
LOAD Case,
Value_Name,
Value
FROM
[..\..\..\Downloads\example.xlsx]
(ooxml, embedded labels, table is Sheet2);