Hi Excel Experts,
I want to transpose columns to rows.
I have a data in Sheet1 as below:
Akin 79
Akin 106
Akin 134
Akin 121
Arnett 477
Arnett 423
Arnett186
Arnett 129
Arnett 562
And I need to get data arranged in the following way, i.e. the values on the second column to be displayed in a single row against their respective unique name.
Akin 79 106 134 121
Arnett 477 423 186 129 562
THNKS IN ADVANCE
Bookmarks