Having some issues with pivoting my data
what my data currently looks like :
| id | Account | score1 | score2 | date |
| 1 | A | 89 | 89 | 01/09/2020 |
| 2 | A | 79 | 77 | 01/09/2020 |
| 3 | A | 45 | 56 | 01/09/2020 |
| 4 | A | 34 | 56 | 01/09/2020 |
| 5 | A | 56 | 23 | 01/08/2020 |
| 6 | A | 45 | 45 | 01/08/2020 |
| 7 | A | 89 | 45 | 01/08/2020 |
| 8 | A | 89 | 56 | 01/08/2020 |
what I want it to look like:
| ScoreType | Score | Id | Account | Date |
| Score 1 | 89 | 1 | A | 01/09/2020 |
| Score 2 | 89 | 1 | A | 01/09/2020 |
| Score 1 | 79 | 2 | A | 01/09/2020 |
| Score 2 | 77 | 2 | A | 01/09/2020 |
| Score 1 | 45 | 3 | A | 01/09/2020 |
| Score 2 | 56 | 3 | A | 01/09/2020 |
| Score 1 | 34 | 4 | A | 01/09/2020 |
| Score 2 | 56 | 4 | A | 01/09/2020 |
| Score 1 | 56 | 5 | A | 01/08/2020 |
| Score 2 | 23 | 5 | A | 01/08/2020 |
| Score 1 | 45 | 6 | A | 01/08/2020 |
| Score 2 | 45 | 6 | A | 01/08/2020 |
| Score 1 | 89 | 7 | A | 01/08/2020 |
| Score 2 | 45 | 7 | A | 01/08/2020 |
| Score 1 | 89 | 8 | A | 01/08/2020 |
| Score 2 | 56 | 8 | A | 01/08/2020 |
Could anyone suggest an easy way in alteryx?
