Jun 08 2022 07:13 AM
I have a Stripe payments report exported into Excel. However the Description Column ( say Column A) only records new text Order Numbers. So if a transaction has 12 items on 12 rows say A1 to A12 it has only text in the first row A1. I need the text order number in every line.
If I create a new column B what is the IF formula I should write to check if A has text to copy it into B, if A is blank then copy the text that was copied in the previous row ?
Jun 08 2022 07:59 AM
In B1: =A1
In B2: =IF(A2="",B1,A2)
Fill down.
As an alternative, fill in the blanks in column A itself: