Each week Spotify playlists get updated with new songs and we add them to this ever-growing song catalog: https://airtable.com/shrel3RqIcyz0mjdt
Multiple songwriters can contribute to each song, and we add each songwriter separately (one per column)
Over time we expect the same songwriter to contribute to other songs that eventually get added to this catalog
The goal is to create a table that displays unique songwriters in column 1, the songs each songwriter has contributed to (ideally as linked records), and the total number of songs each songwriter contributed to. I don’t know how to create this table based on the input table linked above.
The pool of songwriters is already huge and growing, so it’s not feasible to have a pre-existing list of names to choose from when populating the input table.
Any suggestions on how to approach this are greatly appreciated!