Here is the worksheet:
a a1
a a2
a a3
b b1
b b2
b b3

I hope to see below result
a a1 a2 a3
b b1 b2 b3

I am new to Macro. Please advise how to use formula to get the result.
Thanks!