需要将行更改为动态列 [英] Need to Change row to dynamic column

问题描述

我有类似
的情况

I have scenario like

User | Session | Response
_________________________
 u1  |   s1    |    r1
_________________________
 u1  |   s1    |    r2
_________________________
 u1  |   s2    |    r3
_________________________
 u2  |   s2    |    r4
_________________________
 u2  |   s2    |    r5

并且输出必须像

输出表
________________

AND the Output needs to be Like

OUT PUT Table
________________

User  | Session  | response1  | response2  | Session.....n
________________________________________
u1    |  s1      |   r1       |  r2       
________________________________________
u1    |  s2      |   r3       |  NULL   
________________________________________
u2    |  s2      |   r4       |  r5      

该会话列可能是n次，具体取决于响应数.

等待回应
在此先感谢

[edit]添加了文本块[/edit]

That Session column may be n time depending upon number responses.

Waiting For response
Thanks in Advance

[edit]text block added[/edit]

推荐答案

被称为" ^ ].

这篇关于需要将行更改为动态列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！