This is hard to explain so I've attached an example of what I need.
Basically there are authors for each book and they are listed in separate columns but I need them in a single column.
For my data there are thousands of rows and heaps of columns (some books have 50+ authors so that is 50+ columns).
I'm pretty clueless with the macro language so help would be great. Thanks.
Bookmarks