duplicating Data Macro

Hello.

I am in need of help for creating a macro that will duplicate 6 entries of many colums to match column entry AJ.

if you look in AJ, it has 6 entries for a single gene, and I am looking for a macro that will duplicate all the other entries to have a one to one correspondence with the column AJ.

I will appreciate all your help.