arrangement

[sahil]

I've vertically data in each cell like this.

A1 john
A2 sam
A3 robin
A4 xxx
A5 xxx
A6 yourself
A7 xxx
A8 no need

So on..... in very large amount.


But need substitution here.
I dont want "xxx".

I mean I need data in B row vertically but like this.

B1 john
B2 sam
B3 robin
B6 yourself
B8 no need


Please suggest any formula for the "B" cells.


Sahil.

 

[sahil]

great Pgc01 ...

I appreciate your effort .

it works coollllllll.