I have 30K of rows similar to this: NameUIDField1Field2Field3hostname 1blah1x hostname 1blah1 x hostname 1blah1 xhostname 2blah2 x hostname 2blah2x hostname 2blah2 hostname 3blah3 xhostname 3blah3 x hostname 3blah3x What I need to do is have the data end up like this: hostname 1blah1xxxhostname 2blah2xxohostname 3blah3xxx 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?!?

Merging rows with data in different fields

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?!?

Workflow

Datasets

Data Investigation

Accepted answers

jrobiso2

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