Macro to move data to single row

[salvdali]

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.