Hi Andrew,

Using your method I can create a column for each of our warehouse quantities, however, each item is still listed 4 times using 4 rows. Is there a way to have each item use only 1 row and show the quantity at each location in the 4 columns?

Current result:
Item# Whse#1 Whse#2 Whse#3 Whse#4
AA123 5 0 0 0
AA123 0 7 0 0
AA123 0 0 2 0
AA123 0 0 0 8


Desired result:
Item# Whse#1 Whse#2 Whse#3 Whse#4
AA123 5 7 2 8