Col A is the material #
Col B -G is the warehouse number and the data is the quantity sold
i want to come up with
Col A material #
Col B warehouse number
Col C qty sold
how do I do this?
thanks
Please use Power Query to transform the data. If I understand right, the columns from B to G have Warehouse numbers below which you have quantities. So, go to Data and click From Table/Range which will take you to Power Query window and from there in Transform menu, you can unpivot other columns by selecting columns from B to G and then load as a table. I have attached herewith a sample excel for your easier reference please.
Thanks! That worked
now I have that data in yellow ( from the power query) and I need to vlookup it to the data in Col A-C how do I do that to incorporate the different whose/qty
You are welcome. Please find the attached sample 2. You have to concatenate Material no. & Whose number to get a unique identifier with which you have to lookup for the value from the yellow table. Please refer to the attached excel.