Hi All,

I need help with transposigng rows into columns.

here is what i have
colA ColB
aaa 11
aaa 22
aaa 33
aaa 44
bbb 55
bbb 66
bbb 77
ccc 88
ccc 99

And this is what I need after transposing.

aa 11 22 33 44
bbb 55 66 66
ccc 88 99

Is there a way to do this using transposing?

Or by using Pivot tables?

Please let me know