Grouping issues

[saurabh79]

Hi Guys, 

I am trying to get help with the following issue. I have been working on it for a few days to no avail. Looked everywhere before posting. Basically, i have data spread over several rows relating to one client. I would like to have only one row per client even if it means the number of column increases. So, to illustrate:

What i have:

Customer	Purchase	Car Company	Car Model	Car Cost	TV Model	TV Company	TV Cost	Phone Company	Phone Cost	Laptop Company	Laptop Cost
john Smith	Car	Mitsubishi	Lancer	50,000
john Smith	TV				s-100	GE	10,000
Richard Marx	Phone							Samsung	1000
Richard Marx	Car	Toyota	Hilux	45,000
Bob Brown	Laptop									Dell	2000
Bob Brown	Car	Toyota	Tarago	45000
Roger David	TV				s-100	GE	800

 What i want:

Customer	Car Company	Car Model	Car Cost	TV Model	TV Company	TV Cost	Phone Company	Phone Cost	Laptop Company	Laptop Cost
john Smith	Mitsubishi	Lancer	50,000	s-100	GE	10,000
Richard Marx	Toyota	Hilux	45,000				Samsung	1,000
Bob Brown	Toyota	Tarago	45,000						Dell	2,000
Roger David				s-100	GE	8,000

Many Thanx.

[BenMoss]

A quick and dirty method would be to use the summarize tool.

Grouping by the client name and then using the concatenate function on all of the other fields, at the bottom you would specify no concatenate delimiters.

A more dynamic method would be to transpose all of your fields apart from the name field.

Then filter out rows where the newly created value field is NULL.

Then use the cross tab tool. Your client name field do A be the group by field. Your name field will be your headers field and your value field would be your value field.

I'm mobile so I can't post an example but I'm sure someone else can.

Ben

[ponraj · Accepted solution]

Here is the sample workflow for your case.  Hope this is helpful. 

WorkflowResults

[saurabh79]

Thank you Ponraj. Works like a charm. A lot complicated than i thought (im just a beginner).

Thanks again.