Share
Explore

icon picker
Citations

This is a demonstration of creating linebreaks and separating the citations into their own rows Citations Button V3
Raw Citations
Name
Citations Button
Citations Button V2
Citations Button V3
Count Linebreaks
RightPad Linebreak
Notes
Tickle
Button
1
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
Add Citations
Add Citations
Add Citations
10
Add Linebreaks
Open
Tickle
Delete Non-Citations
There are no rows in this table
Citations
Name
1
BATES07235
2
BATES07237
3
BATES11175
4
BATES11282
5
BATES11285
6
BATES11473
7
BATES11508
8
BATES12015
There are no rows in this table

Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.