Hi anyone can give me a solution for this problem:

My view returns data like this:

select * from myview;

[Id] [Name] [Function] [Functionvalue]

1 Test 1 Testing 1 Answer 1
1 Test 1 Testing 2 Answer 2
1 Test 1 Testing 3 Answer 3
1 Test 1 Testing 4 Answer 4

I want to write a query based on this view, so that my data should look like this:


[Id] [Name] [Testing1] [Testing2] [Testing3] [TEsting4]
1 Test 1 Answer 1 Answer 2 Answer 3 Answer 4

Thanks in advance,
Jee