Find values on an a range of columns and rows and copy them to a column

[vladi305]

I have groups of data on a range of columns and row. Some of those are blank. The solution will be to copy into a column the cells that contain a value.
Notice the picture attached. The groups are the one left wIth a background filled and the column is the one on the right

 

[shaowu459]

it works fine in my mobile office, the formula should be:

=TOCOL(D3:M7/(LEN(D3:M7)>0),3)

 

[shaowu459]

update my formula:

=TOCOL(D3:M7/(LEN(D3:M7)>0),3)

if source data contains number and text, please use Fluff's solution.

 

[Fluff]

If you type =to into a cell does the autocomplete options include TOCOL?

 

[vladi305]

If you type =to into a cell does the autocomplete options include TOCOL?

Yes I get the autocomplete

 

[vladi305]

The containing formulas are: =IF(Freq!K17<10,Freq!K3,"")
The data format is General

 

[Fluff]

If you have the tocol function, then I don't understand why it's not working.
The formula I posted should work work with text & numbers, whilst the formula by shaowu459 should work with numbers.

 

[vladi305]

I tried this formula in another new worksheet and it works fine
both
=TOCOL(A1:I2,3) without formulas and it remove blanks
=TOCOL(IF(A1:J2="",x,A1:J2),3) Your method works fine as well with formulas

This worksheet i'm working on is saved as a vba but I dont think this should be an issue

 

[Fluff]

Glad we could help & thanks for the feedback.

 

[vladi305]

Glad we could help & thanks for the feedback.

What do you think is wrong with the one i'm getting the errors? I'll try closing and opening

 

[Fluff]

I've no idea, can you post the data & formulae using the XL2BB add-in?