Going to be very tough to explain but I'll give it my best shot. I have some fields I'm trying to report on, IP and ID. There can be multiple duplicate ID's per IP, and vice versa. I would like to remove duplicate ID's per IP, but can't dedup on ID because some IP's could have the same ID. I also tried stats values(ID) by IP, but there are other fields that also need to be reported on and from my research I couldn't find a way to use multiple values. Example: What I currently get IP1 ID1 IP1 ID1 IP1 ID2 IP1 ID2 IP2 ID1 IP2 ID1 IP2 ID2 IP2 ID2 What I want to get IP1 ID1 IP1 ID2 IP2 ID1 IP2 ID2 OR (Preferably) in table format IP 1 ID1 Name ID2 Name -------------------------| IP 2 ID1 Name ID2 Name
... View more