Macro to move data to single row

Hi, hoping someone has some insight.

I have an excel spreadsheet (attached) and I want to be able to select some cells e.g C2:E4 and move the data from each row into new columns in the previous row e.g. Row 1 in this case.

Is there a macro I can use to accomplish this task? I know I would probably have to select the cells I want moved to the new columns myself, but anything that would help me avoid physically cutting and pasting each row manually would be a huge help.

Thanks for the replies.

I am sending the file back the new name is
moving_to_rows salvdali.xls

1 YOU ARE MESSING UP WITH DATA. SO SAVE THE FILE SOEMWHERE SAFELY FOR EASY RETIEVAL
2.i HAVE INSERTED A NEW SHEET IN THIS FILE AND CALLED IT "sheet3"
3.I COPIED THE DATA IN SHEET ("data I have") TO sheet3 for retrieval if necessary
4. THE MACROS ARE IN VB EDITOR MODULE 1

In the file I have sent the sheet 1 is after I have run the mcro "test'

for rechecking
1.RUN undo
2.check whether the old data is copied to first sheet
3.run test

CONFIRM WHETHER YOU GOT WHAT YOU WANT.

for compeltion sake I am copying the the macros below

Please Login or Register  to view this content.

Please Login or Register  to view this content.