Multiple Rows to Single Row

[dataguy]

Hi,

I have the original data set (see below) that I want to transform into desired data set (see below). I have been trying to summarize and concatenate with not a lot of success. I would really appreciate any help in this matter.

Original Data set:

Id	Product	Number of Passed Courses	Number of times failed
1	A	2	0
1	B	3	1
1	C	4	1
2	A	6	1
2	C	5	2

Desired Data set:

Id	A # of Pass	A # of fail	B # of Pass	B # of fail	C # of Pass	C # of Fail
1	2	0	3	1	4	1
2	6	1	0	0	5	2

[gnans19 · Accepted solution]

@dataguy Combination of Transpose and Crosstab would do the magic.

Attached workflow. Hope this helps.\

P.S:. Having # in column names is replaced by underscore by Alteryx

[dataguy]

Thanks! I am working on this. Overall, this looks good.