Cross Tab/Transpose

Sidey1978

Hi all

I am attempting to move a list of data from one column to multiple:

The country column is the data a need to list in individual columns. There is an additional column before connection type with client names (I didn't include as this is sensitive) but I need to group by name and then list all countries associated. I thought that Cross Tab would be the best way to achieve this but I haven't made it work yet...

Can anyone help?

Thanks

Jonathan

Reporting

Parse

Common Use Cases

Accepted answers

bharti_dalal

Hi @Sidey1978,

What I have understood from your Query is that you want to Group by "Name", Create new column headers by Country and you want your connection type values in their respective countries.

if this is what you want, see the screen shot and attached workflow for your reference.

Cross Tab solution.yxzp

All comments

mbarone

Can you provide a before and after picture of the data? Dummy data is fine. I think you just want to configure the cross tab tool as such: group on name, your column headers will be the country field, and your value field would be your connection type.

But without seeing a before and after I can't say for sure.

haroon_sa

Hey @Sidey1978

I probably think that you need something like this...

Take a look at my attached photo. I've used summarize tool to group by the name and concatenate the countries together in a single row.

Hope it helps. If any queries let me know.

bharti_dalal

Hi @Sidey1978,

What I have understood from your Query is that you want to Group by "Name", Create new column headers by Country and you want your connection type values in their respective countries.

if this is what you want, see the screen shot and attached workflow for your reference.

Cross Tab solution.yxzp

Sidey1978

Thanks one and all for your help with this!

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703