Moving line to a column
 

I have two stores. I have a spreadsheet generated by company software that
shows inventory at both stores, but on separate lines. For example:

Store Item Qty
1 A 4
2 A 6

I want to start another column next to "Qty" and make it "Qty Storer 2",
move the "6" in that column next to the "4" and then get rid of the second
line. Can anyone help with that problem?