Macro help: Transpose row to column & Copy, paste data

[harky]

Hi, i need some help. But not sure if someone able to help me.
I using excel 2010.

This is how my data is
​

The Macro will Transpose COL E (Font format had to retain (like colour, bold or underline)

Once transpose, marco will copy and paste the main row data and fill up the blank.

(like u see in the pic, which highlighted in yellow are filled up base on the main row.)

will appreciate someone could help me. thanks million

 

[alansidman]

In power query, simply unpivot columns E:J.

 

[harky]

it had some colour code on font for some highlight . It wont retain my colour if i use power query

In power query, simply unpivot columns E:J.

 

[alansidman]

It wont retain my colour if i use power query

True. It is something you would change afterwards in Excel.

 

[harky]

cant.. i had thousand data.. not possible. tht y i want to use macro. The current code work well 80% but i dont know change it, (remove the autofill part).

It wont retain my colour if i use power query

True. It is something you would change afterwards in Excel.

 

[Fluff]

Duplicate Macro help: Transpose base on column

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).