Tiling data into columns from rows based on responder

[Pmanyoni_oldmutual]

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

[binu_acs · Accepted solution]

@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.