The conversation between human and AI assistant.
How can I copy data of 2nd Column in the 3rd column from immediately preceding row that contains unique number in the 1st column using one formula?
Sure. Here it is: 

| Column 1 | Column 2 | Column 3 |
|----------|----------|----------|
| 1        | apple    |          |
| 1        | banana   |          |
| 2        | orange   |          |
| 3        | grape    |          |
| 4        | pear     |          |
| 4        | kiwi     |          |
I see. And just to clarify, you want to copy the data from the second column into the third column for each row, except the rows where the first column has a repeated value, in which case you want to copy the data from the second column from the immediately preceding row with a unique value in the first column.