Need to have data in one column
I have below data in my excel sheet:--
user1 a1 a2 a3
user2 b1 b2 b3
user3 c1 c2 c3
and i need it this way:--
user1 a1
user1 a2
user1 a3
user2 b1
user2 b2
user2 b3
user3 c1
user3 c2
user3 c3
Can anyone please help me in this...
Thanks in advance..!
|