AnsweredAssumed Answered

Can anyone help me with data transpose?

Question asked by VelmuruganKanagasabai7851 on May 2, 2016
Latest reply on Nov 8, 2017 by 51662476


Hi,

 

I am looking for methods to transpose data. Below is an example

Table 1: Original Data Format

Employee IDPayComponentAmount
Emp1basic100
Emp1HRA300
emp1Allowance120
emp2basic200
emp2HRA233
emp2Allowance212

 

Table 2: Desired/Expected Format

Emp IDBasicHRAAllowance
Emp1100300120
Emp2200233212

 

 

i have tried with nested if conditions using scripting but no luck. Please help/suggest. Thank you in advance

 

 

-Vel

Outcomes