The following code works with below data.
ID USERID CITY STORE_TYPE CITY_ID
1 1 LONDON 1 6
2 1 LIVERPOOL 2 2
SELECT A.USERID ,
MAX(CASE WHEN A.STORE_TYPE = 1
THEN A.CITY_ID END) AS STORE_ID,
MAX(CASE WHEN A.STORE_TYPE = 2
THEN A.CITY_ID END) AS OUTLETID
FROM TMP_USERS_TOUCH_POINT A
GROUP BY A.USERID
Output:
USERID STORE_ID OUTLETID
1 6 2
Hope this helps you.