I hope someone will come to my rescue. I have the following data and need to structure/tile it in columns. My initial data is as follows: IDName Value222Name Mel222OrgHTML222StageCompleted223Name Susan223OrgVisio223StageIn Progress224Name Kenan224OrgJD Group224StageCompleted this is what I want data to look like 222223224NameMelSusanKenanOrgHTML VisioJG GroupStageCompleted Data Tiles.xlsx

Tiling data into columns from rows based on responder

I hope someone will come to my rescue. I have the following data and need to structure/tile it in columns. My initial data is as follows:

ID	Name	Value
222	Name	Mel
222	Org	HTML
222	Stage	Completed
223	Name	Susan
223	Org	Visio
223	Stage	In Progress
224	Name	Kenan
224	Org	JD Group
224	Stage	Completed

this is what I want data to look like

	222	223	224
Name	Mel	Susan	Kenan
Org	HTML	Visio	JG Group
Stage	Completed

Data Tiles.xlsx

Datasets

Accepted answers

binu_acs

@Pmanyoni_oldmutual have you tried the cross-tab tool?

All comments

binu_acs

@Pmanyoni_oldmutual have you tried the cross-tab tool?

OTrieger

@Pmanyoni_oldmutual
I believe that this question was raised several times on this community. If you have googled your question you would find the solution and would save waiting time to go a respond. In some cases there are attached workflows so you have the full solution.

Pmanyoni_oldmutual

Thanks, I went through some and there were minor differences. I could have used them and made my own tweaks but next time. Thanks though.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703