我有下表，但不确定是否可以透视表中的某些列：

CREATE TABLE #test ( id int, Area varchar(10), [grouping] varchar(15), task_1 int, task_2 int)

INSERT INTO #test Values (10,'A','HighNeeds',1, 10)
INSERT INTO #test Values (10,'B','HighNeeds',1, 12)
INSERT INTO #test Values (12,'C','Non HighNeeds',2, 14)

select * from #test
-------------------------------------------------
id  Area    grouping        task_1  task_2
10  A       HighNeeds       1       10
10  B       HighNeeds       1       12
12  C       Non HighNeeds   2       14

What I'm trying to get is:
-------------------------------------------------
id  Area    Tasks      HighNeeds   Non HighNeeds   
10  A       task_1     1           NULL
10  A       task_2     10          NULL
10  B       task_1     1           NULL
10  B       task_2     12          NULL
12  C       task_1     NULL        2
12  C       takk_2     NULL        14

基本上，我试图保留ID和Area列，但将数据和任务列分组。