If I have a list of citations in one column of one row, is there a formula that will take them and put each one on a row of its own? The vastly helpful Billy_Jackson out in the Community has solved the list comparison problem we discussed, where one list was compared to another to see if there were new entries. ( I realized, as did he, we were comparing lists that existed inside the columns of a row. When you transfer the column items to be one in each row of a table, then they can be compared and the new ones noted.) So, that generates the question of creating a new row in a table for each new entry that appears in the list in the one column of one row to compare with the main list (which is a table) to see whether the new entries are already in the table, and, if not, add new rows for them. The list comes in from the text reader in one column of one row like this:
BATES07235
BATES07237
BATES11175
BATES11282
BATES11285
BATES11473
BATES11508
BATES12015
But if I can convert each entry to be in its own row, then I can compare it like this: https://coda.io/d/Legal-Copy-of-Document-Comparison_dIpsXJRV3E2/Document-Comparison_suyJd
10
Open