Help making a Macro to transpose data

[lwilt]

I had to make changes to my previous data set and now my macro isn't working for it so I am hoping someone can help me make a new one. I have 3 columns and want to transpose what is in columns 2 and 3 so that each item now only shows up in one single row. The data currently looks like:

sku1	Q	P
AF121C60
AK18025	6	9
AK18025	12	8.5
AK18025	24	8
AK18025	36	7.25
AB411FIR	3	54
AB411FIR	6	52
AB411FIR	12	50
AB411FIR	24	48
AE120AUS	3	60
AE120AUS	6	56.25
AE120AUS	12	53.13
AE120AUS	24	50
AY521	15	156
AY521	9	159
AY521	6	162
AY521	3	165
AY521
AY521
AY521
AY521
AY521
AY521
AY521
AY521
AY521
AY521
AY521
AY522	3	183.5
AY522	6	179
AY522	9	169
AY522	15	163
AY522
AY522
AY522

<colgroup><col><col><col></colgroup><tbody>
</tbody>

As you can see each item shows up multiple rows and I would like it to be in a singular row with the data going horizontal.

 

[InfoH]

if you have a macro create a new sheet or go to an empty sheet, copy the data, have your VBA macro do:

Selection.PasteSpecial Paste:=xlPasteAll, Operation:=xlNone, SkipBlanks:=False, Transpose:=True

then have it copy it again from the new location and put it back into the old location

Make sense?

 

[lwilt]

will it matter that I removed one of the columns from the sheet that the original macro was using?

 

[lwilt]

can anyone help?? a bit confused by the previous reply