Change column into rows and group the data

Hi,

Can someone please give me a hand on converting the data below. I have tried to use Transpose but couldn't work it out the correct output. Thanks!!

Input data

Record	Name	Type	Count
1	AA	X	5
2	AA	Y	8
3	BB	X	9
4	BB	Y	10

Desire Outcome

Record	Name	X	Y
1	AA	5	8
2	BB	9	10

Data Investigation

Accepted answers

IraWatt

Hey @eddyai,

You can use a cross tab tool to achieve this:

Any questions or issues please ask
HTH!
Ira

Workflow.yxmd

FilipR

Use Cross Tab:

All comments

IraWatt

Hey @eddyai,

You can use a cross tab tool to achieve this:

Any questions or issues please ask
HTH!
Ira

Workflow.yxmd

FilipR

Use Cross Tab:

binu_acs

@eddyai Another way of doing this with the Tile and cross tab tool

CrossTab_01_07.yxmd

camie

you can use cross tab. I just added Record ID tool after the cross tab just in case you'll need an "ID" field.

Cross Tab configuration:

Quick Links

Unanswered
Community Events
Groups

This months top contributors

SophiaF 432

AkimasaKajitani 390

mceleavey 388

mbarone 337

michael_weaver 335