Hi everyone,
I am trying to convert unique values in a column to separate rows, see below the sample data and expected output. I have tried using 'text to columns', 'Transpose', and 'Cross Tab' fields but couldn't achieve the expected outcome.
Can someone please help me out.
Sample Data
EE Number | Earning Type | Amount |
1 | a | 2000 |
2 | b | 4000 |
3 | c | 6000 |
4 | d | 8000 |
5 | e | 10000 |
1 | b | 3000 |
3 | e | 5000 |
Expected Output
EE Number | a | b | c | d | e |
1 | 2000 | 3000 | |||
2 | 4000 | ||||
3 | 6000 | 5000 | |||
4 | 8000 | ||||
5 | 10000 |
Thanks in advance.
Solved! Go to Solution.
It worked! Thank you for a quick response.