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.
