Split One Column and Transpose it as Header
Hi, I am having problem to split columns and transpose it as header and value. Need help here how to write the code.My data table has four columns, Item, Part Number, Order Number and Quantity.I need to split Order Number and transpose it as header in new column and split Quantity column transpose it to respective cell.I attach my data table here and required outcome for your reference. I know th...