Really hard!!! Copy data from column B to C and add empty cells.Please see example.

Hello
I have text data in column A and B. What I'm trying to do is copy data from column B to C. But if A(n)<>A(n-1) then I need to add extra blank cell into column C.
Please see example below.


Column A.......................Column B.................................OUTPUT Column C
TEXT1.........................."cell B1 is always empty" ..........."empty cell"
TEXT1..........................Random Text A......................... Random Text A
TEXT2..........................Random Text B.........................."empty cell on transition from TEXT1 to TEXT2" note... If(A3<>A2, Then empty cell)
TEXT2..........................Random Text C..........................Random Text B
TEXT3..........................Random Text D.........................."empty cell on transition from TEXT2 to TEXT3"
TEXT3..........................Random Text E.......................... Random Text C
TEXT3......................... Random Text F.......................... Random Text D
TEXT4..........................Random Text G.......................... "empty cell on transition from TEXT3 to TEXT4"
TEXT4..........................Random Text H............................Random Text E
TEXT4..........................Random Text I.............................Random Text F
TEXT2..........................Random Text J............................."empty cell on transition from TEXT4 to TEXT2"
TEXT2..........................Random Text L..............................Random Text G
TEXT5..........................Random Text M............................."empty cell on transition from TEXT2 to TEXT5"
TEXT5..........................Random Text N............................. Random Text H
. . .
. . .
. . .

*"Dots are used just to properly format text."

So basically every time A(n) <> A(n-1) then C(n) = "empty cell"
If A(n) = A(n-1) then write next text string from column B into cell C(n)

Hopefully I'm clear enough. It is quite hard to explain it properly.


Thank you very much.

Thank you very much PCI. It works exactly as I need.