Transpose n rows to column

[NidhiAg]

Hi Team,

I am kind of lost between Transpose and CrossTab here

Input Data

ColumnName	Value
A.1.a	11
B.1.b	22
A.2.a	33
B.2.b	44
C.2.c	55
D.2.d	33
A.3.a	22
B.3.b	44
C.3.c	55
D.3.d	66

I need to Transpose or CrossTab it to below form

A	B	C	D
11	22
33	44	55	33
22	44	55	66

[NidhiAg · Accepted solution]

Woohhoo Solved it. Got that number in between as column and then group by using CrossTab