Ok. So I am trying to take a paragraph from the first row of the first column of my table, use the split formula to split the paragraph into individual sentences, and then display those sentences in their own individual rows in another column. But I am having trouble referencing the correct data. I need to be referencing only one row in one column (that one paragraph) but my formulas are only referencing their own rows, which are blank because I wrote the paragraph in only the top row. Here is a pic:
I wrote something in the second row of ‘Paragraph plot’ to show how it is taking the data from that row, rather than the first row the way I want it to. I know that everything would work fine if I had a way of automatically copying that first paragraph into all the following rows of ‘Paragraph Plot’, so that all the formulas are referencing that same paragraph, rather than referencing a blank row. I don’t know how to do that, though, or if that is the best solution to my problem.