Merging rows with data in different fields

[jrobiso2]

I have 30K of rows similar to this:

Name	UID	Field1	Field2	Field3
hostname 1	blah1	x
hostname 1	blah1		x
hostname 1	blah1			x
hostname 2	blah2		x
hostname 2	blah2	x
hostname 2	blah2
hostname 3	blah3			x
hostname 3	blah3		x
hostname 3	blah3	x

What I need to do is have the data end up like this:

hostname 1	blah1	x	x	x
hostname 2	blah2	x	x	o
hostname 3	blah3	x	x	x

I don't seem to be getting anywhere, either with Summary, or Multi-Row Formula, etc. I KNOW this should be easy, but the solution just isn't coming to me.

Help?!?

[MilindG]

I have attached couple ways. See if that works

[jrobiso2]

Nice. Unfortunately, my boxes don't show that x can exist for the same field in more than one row, so the concat results in x,x,x, etc.

I'm thinking perhaps Max instead of Concat?

[jrobiso2 · Accepted solution]

Got it! 

Formula to turn any "N/A" entry in the 3 Fields to blank, then a Summarize, grouping on all columns except those 3 . . . those 3 I use "Max" in the Summarize tool. (My Field values are 3 letter acronyms, hence the need to remove any "N/A" values, as those are 3 characters - so blank those to make Max work).

Thanks for the ideas in your Merge file!

[MilindG]

Awesome, Glad you found the solution. Cheers!