MySQL 5.7

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE Logs(IP VARCHAR(50),UserID VARCHAR(50),Data VARCHAR(50))
INSERT INTO Logs VALUES
 ('12.34.56.78','abcde',NULL),     
 ('12.34.56.78','abcde',NULL),  
 ('12.34.56.78','fghij',NULL), 
 ('12.34.56.78',NULL,'utm_source = email'),
 ('12.34.56.78',NULL,'utm_source = email2'),
 ('12.34.56.78',NULL,'vtm_source = email3'), 
 ('87.65.43.21','xxxxx',NULL),
 ('19.28.11.11','random',NULL),
 ('19.28.11.11','random',NULL),
 ('19.28.11.11',NULL,'utm_source = newsletter')
SELECT `ip`, 
       GROUP_CONCAT(DISTINCT 
                        CASE
                        WHEN `Data` LIKE '%utm%'
                        THEN
                             `Data`
                         END
                      ) AS Datas,
       GROUP_CONCAT(DISTINCT 
                             `UserID`
                      ) AS UserIDs
  FROM Logs
 GROUP BY `ip`
HAVING MAX(`UserID`) IS NOT NULL AND MAX(`Data`) IS NOT NULL


ip
Datas
UserIDs


12.34.56.78
utm_source = email,utm_source = email2
abcde,fghij

19.28.11.11
utm_source = newsletter
random

ip	Datas	UserIDs
12.34.56.78	utm_source = email,utm_source = email2	abcde,fghij
19.28.11.11	utm_source = newsletter	random