Crosstab

[aparna0208]

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

[BS_THE_ANALYST · Accepted solution]

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

[MeganJones]

This is a great question. Good to know!

[BS_THE_ANALYST]

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

[binuacs · Accepted solution]

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

[BS_THE_ANALYST]

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

[aparna0208]

@BS_THE_ANALYST @binuacs  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