Urgent help in macro

Hello,

happy nEW year i need your urgent help in macro . i have some data like below in excel

A B C E F
Customer Name RDS ID Device ID Product Name Installation Date (dd-mm-yyyy)
abc MSR01437 MSR01437 iR2230 22-04-2010

G H I J K L M
Date and Time LastReceived Total BA3 BA4 CA3 CA4 B C
31-12-2010 12:16 516299 5221 511078 0 0 516299 0


AND I NEED ABOVE DATA CONVERT LIKE BELOW FORMAT


A B C D E
Customer Name RDS ID Device ID Counter Date
ABC MSR01437 MSR01437 516299 31-12-10
ABC MSR01437 MSR01437-BA3 5221 31-12-10
ABC MSR01437 MSR01437-BA4 511078 31-12-10
ABC MSR01437 MSR01437-CA3 0 31-12-10
ABC MSR01437 MSR01437-CA4 0 31-12-10
ABC MSR01437 MSR01437-B 516299 31-12-10
ABC MSR01437 MSR01437-C 0 31-12-10

Thanks in advance for your answer!