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