Thank you so much, Ashish!
Christoph
On Wednesday, April 3, 2013 9:54:52 AM UTC-4, ashish wrote:
> apply filter in colb -> choose blanks -> simply type formula in first
> blank cell of col b like =A3 ->
>
> and fill-down formula till required -> remove filter ->
>
> then copy and paste special
apply filter in colb -> choose blanks -> simply type formula in first
blank cell of col b like =A3 ->
and fill-down formula till required -> remove filter ->
then copy and paste special col b data
Regards
Ashish
On Wed, Apr 3, 2013 at 7:16 PM, Chris wrote:
>
> Morning!
>
> I'm often fa
Morning!
I'm often faced with the following problem (simplified here): I have data
in the following cells of a spreadsheet:
A1, B2, A3, B4, A5, B6
and would like to copy column A a paste it into B so that there are no
gaps, basically turning the two colums showing zigzag data into one. Of