I have information that was saved in Excel in the past year data. I am unable to load data from Excel as you can see at the attachment. The challenge is for me, row base data shown in the Excel columns as you can find Project No. with starting 1 to 3 and this column is dynamicaly changes according to project number count. And related to project numbers; the quantity fields listed under the columns. Some Excel cells also merged.
1.Step; i want to transpose columns to row related with project number and quantity,
2.Step; i want to multiply quantity with USD values listed with column name Poz No
