I have a spreadsheet with about 1000 rows and 6 columns. Below is a link to a screen show of 8 rows. You will notice that a name is listed 4 times with $$ on different rows. I need for all of the $$ to be on the top row for each name listed. I tried recording a macro, but I was not able to get it to work correctly. Is there a way to do this automatically without having to move each amount up manually.

In this example, C2 would move to C1, D3 would move to D1 and E4 would move to E1. I don't mind addressing each section of 4 names and automating just those and moving to the next 4. It's just very labor intensive to move each single amount.


https://dl.dropboxusercontent.com/u/...Document18.pdf

Hi
please post a sample sheet. Pictures are nice to look at but useless.
Also note that posting on external sites is not a good idea as they are potentially unsafe and cannot be opened by all members.
Thank you

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post