T123456

WITH T1 AS (
SELECT id, Traveloka FROM TABLE WHERE COALESCE(Traveloka,'') <> ''
),
T2 AS (
SELECT id, Agoda FROM TABLE WHERE COALESCE(Agoda,'') <> ''
),
T3 AS (
SELECT id, Expedia FROM TABLE WHERE COALESCE(Expedia,'') <> ''
),
T4 AS (
SELECT id, Tiket FROM TABLE WHERE COALESCE(Tiket,'') <> ''
)
SELECT T1.id, T1.Traveloka, T2.Agoda, T3.Expedia, T4.Tiket FROM T1, T2, T3, T4
WHERE
T1.id = T2.id
AND T1.id = T3.id
AND T1.id = T4.id