Pattern Copying Issue

Hello everyone here,

I have a complex issue and I need your help to solve it together:


I have excel sheet has over 400,000 row extracted from a company database.

The sheet has many Ref. Start with Ho1 and the data below for each reference would like to make it as follow:


there are 2 columns F (Descr 1) & G (Descr 2) and i want to copy the (cell B6 to column F and cell D6 to Column G) beside numbers as shown in attachment and i want the same description to be draged below till the last number for Ref no


anybody can help with equation, VBA anything i will be most appreciated.