Copy non-blank cells

[cranmax]

Hello,

I'm new to this page so hello to all.
I've got two questions and what I want to achieve is Column B:

1. How could I... (I'll explain it the most graphic I can)

Column
A B
Rows: 1 3200
2 3200 world
3
4
5 world

Note: all the cells contain a formula, so the output of A1, A3, A5 is ""

2. How could I transform to Excel date?

Column
A B
Rows: 1 19820421 21/04/1982
2 19820422 22/04/1982
3 19820425 25/04/1982
4 19820426 26/04/1982

Thanks.

 

[AliGW]

I don't get your first request - sorry. It's far from clear.

Second request - this in B1 copied down:

=RIGHT(A1,2)&"/"&MID(A1,5,2)&"/"&LEFT(A1,4)

 

[cranmax]

What a mess! I will put it on an image.

[/url][/IMG]

 

[AliGW]

I've already dealt with your second query. In the first, are you simply looking to eliminate blank rows?

 

[cranmax]

Yes. But the "blank" cells contain formula (I don't know if this is important)

 

[AliGW]

It might be. What is the formula?

 

[cranmax]

I've put an example formula. What I want in th case is column D.

 

[AliGW]

Copy this into B1:

=IFERROR(INDEX($A$1:$A$5,SMALL(IF($B$1:$B$5=1,ROW($A$1:$A$5)),ROWS($A$1:A1))),"")

Confirm by clicking CTRL+SHIFT+ENTER, and then drag down. This is an array formula: confirming it in this way will add curly brackets (braces) to the formula.

You don't need column C for this at all.

 

[FormR]

Hi, welcome aboard!

2. How could I transform to Excel date?

Here is another option for 2. that returns a true excel date (note you may need to format as appropriate).

Excel 2013
	A	B
1	19820421	21/04/1982
2	19820422	22/04/1982
3	19820425	25/04/1982
4	19820426	26/04/1982
Sheet1

Cell Formulas
Range	Formula
B1	=TEXT(A1,"0000-00-00")+0

 

[cranmax]

Copy this into B1:

=IFERROR(INDEX($A$1:$A$5,SMALL(IF($B$1:$B$5=1,ROW($A$1:$A$5)),ROWS($A$1:A1))),"")

Confirm by clicking CTRL+SHIFT+ENTER, and then drag down. This is an array formula: confirming it in this way will add curly brackets (braces) to the formula.

You don't need column C for this at all.

I don't obtain what I'm asking; the output are zeros and the cells have braces like you post. Here's the image similar to the other but without formula.