I need to query the excel sheet as I have constraint of not using excel directly in a application.
Now I need to select only 20 out of 40 columns and pivot approx t0 columns, Problem I am running into is I am unable to Unpivot the excel using query (ms query).
Struggling searching the net for suitable solution but till now unable to achieve Unpivot functionality.
Please experts in this forum if can help with MsQuery code to write a query to unpivot selected columns using Excel datasource.
I managed to select the required column but not sure how to unpivot.
Select * from(
select F2, F3, F4, F5,
Here I need to unpivot F8 and F9 columns and create a result set as
F2 F3 F4 F5 Names Values
Please help, struk for more than a week.