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?!?
Solved! Go to Solution.
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?
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!
Awesome, Glad you found the solution. Cheers!