I have about 100 rows of info. What i need to do is make it about 50. i want to make 2 Rows into 1 Row. I recorded a Cut and Paste macro and it didnt work. It won't paste. Basically it looks like thi

A B C D E
Row 1 - info blankcell info info inf

row 2 - info info info

What I want to accomplish is this......Cut A2 and paste it in B1. Cut D2 and E2 and paste them in D1 an E1 respectively.

Can anyone help

Thanks in advance for your time and effort
Steve.