I have a data source with several different columns of data. There are many
rows wtihin the source. I would like to sort the data and then have the
Macro copy certain information out of the file and paste it into another.

Example: copy product name and type

A B
1 Product Desc
2 Hammer 20 oz
3 Hammer Sledge
4 Hammer 16oz
5 Nails 10p
6 Paint Red
7 Paint Green
8 Paint Blue
9 Paint Yellow
10 Screwdriver Phillips


When the information is pasted into the new file, the columns do not match
the original file.

A B C D E F G H I
1 Product Desc 2 Paint
Red 3 Paint Green
4 Paint Blue 5 Paint
Yellow

Is it possible to do this with a macro? If not, is there a formula/series
of formula that would do this?

Thanks