Copying columns to rows|General Excel Questions & Answers|Excel Forum|My Online Training Hub

Hi Team,

I have a repetitive task to copy several separate columns to rows.

As per attached, I have to copy column B to D (Payrun Group, Emp Code, Emp Name) and column K, column M, column N (Cost Center 1(to Costing Combination), Units 1(Pay Unit), Amount 1(Amount) ) and then repeat column B to D again for Cost Centre 2, then again Cost Centre 3, 4, 5 and so on.

If there is nil value on (Unit)Pay Unit and (Amount)Pay Cost, we can ignore copying the line.

Payrun Group, Payrun and PPE date will be the same for all rows.

Please let me know is there any formula (if it exist, please let me know the module and chapter) or any thing I can do it simpler.

Thank you.

Regards,

Aye