Simple reformatting question

[Shadow Wizard]

I don't use excel much as you will be able to see by the question, but I can't for the life of me figure out how to do what need to do.
I have a stock file of my current stock in this format:

Itemid
quantity
itemid
quantity

The item ID's are not in order. What do I need to do is get it into this format

itemid quantity
itemid quantity
And then sort them alphabetically.

Thanks in advance.

[Jakobshavn]

If your data is in column A starting at A1, in B1 enter:
=INDEX(A:A,2*ROW()-1,1) and copy down
In C1 enter:
=INDEX(A:A,2*ROW(),1) and copy down

Check the results.

Finally copy cols B & C and PasteSpecialValues back onto them.
Then do the sort.

[Shadow Wizard]

Thank you.