stefanaalten
Board Regular
- Joined
- Feb 1, 2011
- Messages
- 68
- Office Version
- 365
- Platform
- Windows
I have data on books and authors in simple two-column format, i.e. book-author pairs:
Author1 Book1
Author1 Book2
Author1 Book3
Author2 Book1
Author2 Book3
Author2 Book4
Authors may have produced more than one book and each book may have multiple authors. I need to turn those cases into rows like this:
Book1 Book2 Author1
Book1 Book3 Author1
Book2 Book3 Author1
Book1 Book3 Author2
Book1 Book4 Author2
Book3 Book4 Author2
In other words, each row will represent where two books are related based on having been written by the same author. I don't have masses of data yet, but as the list grows it will become impractical to do this completely manually - but I'd be happy with a general workflow (e.g. involving copying-pasting), not looking for a fully-automated formula-driven solution necessarily.
The book-pairs will then represent then edges in my graph (the nodes will represent the books).
Can anyone help please?
Author1 Book1
Author1 Book2
Author1 Book3
Author2 Book1
Author2 Book3
Author2 Book4
Authors may have produced more than one book and each book may have multiple authors. I need to turn those cases into rows like this:
Book1 Book2 Author1
Book1 Book3 Author1
Book2 Book3 Author1
Book1 Book3 Author2
Book1 Book4 Author2
Book3 Book4 Author2
In other words, each row will represent where two books are related based on having been written by the same author. I don't have masses of data yet, but as the list grows it will become impractical to do this completely manually - but I'd be happy with a general workflow (e.g. involving copying-pasting), not looking for a fully-automated formula-driven solution necessarily.
The book-pairs will then represent then edges in my graph (the nodes will represent the books).
Can anyone help please?
