How do I combine and average two rows?

[leewa007]

I have the above information and need to combine (for example) Record 1229 and 1230 into one row and the _value needs to be the average of the two values. How do I combine and average the two?

[Luke_C]

@leewa007 

Can you post the following:

1. Sample Data (not a screenshot, the actual data that someone can put into alteryx)
2. Your expected result

That will help everyone advise on the best approach, and potentially mock up a sample for you in alteryx. 

[leewa007]

In the circled above in red I need to be able to combine the following

As you can see in the Postal code is 80125 but on the _station column you can see there are two stations ending 58022 and 57249, I need to combine those two locations and for the _value I need to make sure it adds both and gives me the average for the two locations. 

Thank you in advance

[Luke_C]

Hi @leewa007 

Here's an example of the summarize tool like I described earlier.

[leewa007]

I understand what you are doing but that is still not what I need. :/

I truly appreciate your help though. 

[Luke_C]

Hi @leewa007 

Help us help you - the below blog post might be helpful. As I mentioned above, giving example data (not a screenshot - nobody is retyping all of your data). Give an example output dataset of what you're expecting. That will give us the information on what you need.

https://community.alteryx.com/t5/Alteryx-Community-Resources/Posting-for-Fastest-Possible-Solution/t...