Data Preparation: Cross Tab Tool?

[IJH34]

I am new to Alteryx and am having trouble with data preparation. I am sure this is going to be an easy solution but for some reason I am struggling to format my data accordingly.

Here is what my data looks like:

App ID	10000	10001	10002	10003
260608	3934	NULL	NULL	NULL
260608	NULL	10000	NULL	NULL
260608	NULL	NULL	2251.79	NULL
260608	NULL	NULL	NULL	3618.95
260609	2225	NULL	NULL	NULL
260609	NULL	989	NULL	NULL
260609	NULL	NULL	3261.54	NULL
260609	NULL	NULL	NULL	4829.18

This is what I am looking for:

App ID	10000	10001	10002	10003
260608	3934	10000	2251.79	3618.95
260609	2225	989	361.54	4829.18

I am using the cross tab tool but cannot seem to get all values on the same line for a given application.  

Thanks in advance.

IJH34

[NickC · Accepted solution]

Hello,

You will need to use the Summarize tool to complete this. Group by the 'App ID' then you will need to do a sum on all the remaining fields.  See screenshot below.

Hope this helps.

Nick

[IJH34]

Thanks @NickC. Much appreciated!

[SeanAdams]

Hey @IJH34 - did you manage to get to a solution that worked?

If so, would you mind marking this thread as solved - or if not, lets work together to get you to a solution.

Many thanks - have a good weekend

sean