Need to copy cell value from one column to another based on condition

[Gsiva3]

Hi Team,

Hi @Qiu

I have a column named A & B. If column A is "empty" means, then content from ROW+1 of Column B must be copied. I have attached sample input & sample output. Please help me with this.

[Emil_Kos]

Hi @Gsiva3,

You can achieve this using multi-row formula. 

The output:

[Gsiva3]

Hi @Emil_Kos 

Thanks for the reply.

But my input is like

A	B
1234	ABCD
5678	EFGH
9067	IJKL

And I need output as 

A	B
1234	ABCD
ABCD
5678	EFGH
EFGH
9067	IJKL
IJKL

please help me on this

[Emil_Kos · Accepted solution]

Hi @Gsiva3,

I looked only at the output tab 😀

The output:

[Qiu · Accepted solution]

@Gsiva3 

I am here

[Gsiva3]

thanks @Emil_Kos .

Got it:)

[Gsiva3]

Thanks @Qiu 

Its working😊