Its almost same as the above answer, I have used CASE instead of PIVOT.

Fiddle

WITH NumberedEquipment AS (
    SELECT
        Eqp,
        Date_col,
        Value1,
        ROW_NUMBER() OVER (PARTITION BY Date_col, Value1 ORDER BY Eqp) AS Row_Num
    FROM test_table
)
SELECT
    MAX(CASE WHEN Row_Num = 1 THEN Eqp END) AS "Eqp",
    MAX(CASE WHEN Row_Num = 2 THEN Eqp END) AS "Another Eqp",
    Date_col,
    Value1
FROM NumberedEquipment
GROUP BY Date_col, Value1;

Output