I have a query that is made up of 8 columns. Buyer, Supplier, Shortage 1, Reason 1, Shortage 2, Reason 2, Shortage 3, Reason 3. The shortage column contains part numbers of missing components obviously the reason columns are the reason they are missing.

I need to run this query then I need to take the six columns of shortage and reason and move them into 2 columns so I can create a graph of the reason and quantity of reasons.

example: I want a bar graph that shows 10 items because of supplier out of stock.

This process needs to as automated as possible.



Any help would be appreciated.