I have one excel file with a sheet “OK”.
I need to import the file, i tried:
s = Import["sales.xls", {"Sheets", "OK"}]
header1 = s[[1]];
data = s[[3 ;;]];
sDataset = Thread[header -> #] & /@ data // Map[Association]
But didn’t work because the column headers are in the row 1 and 2 after the column 1. I need:
1.) SALES, GM, %GM and EBITDA pear YEAR per MONTH.
Ideas? Thanks!