Pivot data in Alteryx

[barkat]

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? 

[atcodedog05 · Accepted solution]

Hi @barkat 

Here is a workflow for the task.

Input:

Output:

Workflow:

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

[barkat]

Thank you very ,much 

[atcodedog05]

Happy to help 🙂 @barkat 

Cheers and Happy Analyzing 😀