Forum

Notifications
Clear all

Copying columns to rows

4 Posts
2 Users
0 Reactions
95 Views
(@ayemu7)
Posts: 197
Reputable Member
Topic starter
 

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

 
Posted : 27/04/2019 10:23 pm
(@mynda)
Posts: 4761
Member Admin
 

Hi Aye,

No file attached.

Mynda

 
Posted : 28/04/2019 12:35 am
(@ayemu7)
Posts: 197
Reputable Member
Topic starter
 

Hi Mynda,

Please see attached file. 

Thank you.

Regards,

Aye

 
Posted : 28/04/2019 1:17 am
(@ayemu7)
Posts: 197
Reputable Member
Topic starter
 

Hi Team,

Is that my query out of course contents. Or please let me know is there a way to do that.

Many thanks for all your help.

Regards,

Aye

 
Posted : 06/05/2019 12:48 am
Share: