New to macros, looking for logic assistance

[eastond]

I have been given a task to take data from a spreadsheet i was to create and re-format it so that it has a list of names, and then all skills these people what by there names and how much time they have spent working on these tasks. So that there are no empty cells, and it looks neat and ordered.

As it stands i have a spreadsheet with the max number of columns and 1647 rows, so i cant exactly do it without some help from a macro and my lack of experience with macros makes this alot harder for me.

I need to produce a macro that will help me with my task, and was wondering if anyone had some hints as to how i can go about making this macro? i tried recording one but i screwed it up and my VBA good enough to go through and alter the code to make it do as i need it to.

Any help / advice would be much apreciated.

Thanks.