[Before] I have a list of data arranged in the format as below.
Author A Name B Category C Author 1 Name 2 Catergory 3
[After] How can I combine the data as below so I can sort the data.
Author Name Category A B C 1 2 3
Many Thanks.
Bookmarks