Hello,

I would like some help figuring out how to do the following:

In one sheet I have 5 columns: Location, Item, Description, Qty, Unit Price.

Sheet 1.png

The objective is to comb through the Location column and copy the Location value in a new sheet and then copy all the rows that have that same Location value and past them underneath.

Sheet 2.png

Any help will be appreciated! Thanks!