Cross Tab Help

I am trying to Cross Tab some data based on cell phone service providers. I am having an issue with cross tab not working. I am trying to group together providers based on having the same name but located in a different state. I have attached the data and what the desired result is. Can anyone help?

Cross Tab Data.xlsx

Tips and Tricks

Accepted answers

Qiu

@BrandonS4
It is more a Summarize tool problem?

0126-BrandonS4.yxmd

All comments

Qiu

@BrandonS4
It is more a Summarize tool problem?

0126-BrandonS4.yxmd

BrandonS4

@Qiu Thank you for this suggestion. I have never used the Concatenate function when doing using the Summarize tool so this was good to learn. Very helpful. Thank you very much!

Qiu

@BrandonS4
Glad to help and thank you for the accept mark. 😁

BrandonS4

@Qiu What happens if Verizon is listed in the same state more than once? For example, what if AT&T shows up in GA 3 times? Wouldn't it duplicate the value in the summarize tool using concatenate?

Qiu

@BrandonS4
If AT&T shows up in GA 3 times and you dont want any duplicated names in the "State" column, we can do something like tihs.

0126-BrandonS4 - R1.yxmd

BrandonS4

The issue I am having doing it that way is GA shows up 3 different times for AT&T and they also have 3 different amounts in GA.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15874

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703