Hi, I have data in the below format where I have 4 columns for each set(contact name, title, email and phone). I want to organize and split it horizontally as indicated in 2nd snapshot. I'm confused if I can directly use crosstab tool or should I do like a record id or something to group each set? Need some help on this. Thank you in advance! ValueColumn NameShane SmithContact NameHead of Portfolio Consulting GroupTitle704.777.9876Phoneshane@abc.comEmailDoug DanaContact NameHead of Investment Advisory SpecialistsTitle609.987.3333Phonedd@xyz.comEmail Desired output: Contact Name Title Phone Email Shane Smith Head of Portfolio Consulting Group 704.777.9876 shane@abc.com Doug Dana Head of Investment Advisory Specialists 609.987.3333 dd@xyz.com

Crosstab

Hi,

I have data in the below format where I have 4 columns for each set(contact name, title, email and phone). I want to organize and split it horizontally as indicated in 2nd snapshot. I'm confused if I can directly use crosstab tool or should I do like a record id or something to group each set? Need some help on this. Thank you in advance!

Value	Column Name
Shane Smith	Contact Name
Head of Portfolio Consulting Group	Title
704.777.9876	Phone
shane@abc.com	Email
Doug Dana	Contact Name
Head of Investment Advisory Specialists	Title
609.987.3333	Phone
dd@xyz.com	Email

Desired output:

Contact Name Title Phone Email

Shane Smith Head of Portfolio Consulting Group 704.777.9876 shane@abc.com

Doug Dana Head of Investment Advisory Specialists 609.987.3333 dd@xyz.com

Output

Accepted answers

BS_THE_ANALYST

@aparna0208 here's one way to get this. I can see how it's tricky!

record_formula_Crosstab.yxmd

binu_acs

@aparna0208 another way of doing this with the tile and the cross tab tool

Transpose_140323.yxmd

All comments

BS_THE_ANALYST

@aparna0208 here's one way to get this. I can see how it's tricky!

record_formula_Crosstab.yxmd

MeganJones

This is a great question. Good to know!

BS_THE_ANALYST

@aparna0208 I've never used this way before but it seems interesting!

record_tile_crosstab.yxmd

binu_acs

@aparna0208 another way of doing this with the tile and the cross tab tool

Transpose_140323.yxmd

BS_THE_ANALYST

@binu_acsNice solution! definitely only 1 Tile tool needed; I overcomplicated that 😁.

aparna0208

@BS_THE_ANALYST @binu_acs Thank you so much:) Both solutions worked, one with record id and the other one using one tile. This tile concept was new to me and happy that I learnt something new today.

Satishpitta

@binuacs

A new way of learning and i never used Tile Tool before.. now explored the tool.

Thanks

Satish

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703