Help with macro to transpose data

Dear all

i have been tasked to transpose data to columns. at the end of a given month two values are subtracted from a member's portion. each member has a unique reference.

Please note:

1. that some members had nothing subtracted for some months.
2. the resultant data will be such that each member will occupy one row, with values per month in different columns. after values from column B, then values from column C start (the columns will be labeled respectively
3. Ref number are highlighted in yellow for the first few members. Please ignore the totals in the same rows as the Ref numbers.

The data is attached here. and the format i am expecting after running the macro is in "sheet 1" for the first few members.

Your help will be greatly appreciated

See attached file where I used this macro to transpose data as you asked.

Please Login or Register  to view this content.

Regards,
Antonio

Different method

Please Login or Register  to view this content.

you guys are geniuses. Antoka's code worked perfectly while Jindon's worked for some months. You just made my life easier and thank you so much

This forum is a must visit