Structure the data horizontally in SQL server

See more:

SQL

SQL-Server

Hi I have a query which returns data as below

select n.Key, np.value from Test1 np join Test2 n on n.Key = np.Key where n.NodeKey = 10000002 && np.pKey in (4,6,7,10,12)

which returns data as below

Key value
-------- ------
10000002 2
10000002 0
10000002 2
10000002 True
10000002 1

Test2 is look up Table as below

Key PKey Value
---------------------------------------
10000002 4 2
10000002 6 0
10000002 7 2
10000002 10 True
10000002 12 1


Wanted to change the query so that it should return data as below

NodeKey Value1 Value2 Value3 Value4 Value5
--------------------------------------------------
10000002 2 0 2 True 1

Can you please help me with this.

What I have tried:

Tried restructuring the query so that it returns data horizontally