I am getting the out put of a query as

SN NodeName NodeValue

1 Address address1

1 Address address2

1 Address address3

2 city kol

3 providerID 1

3 providerID 3

3 providerID 2

now i have to just customize(re-arrange) it to different record set.

ProviderId Address City

1 address1 NULL

2 address2 NULL

3 address3 kol