Formula to Stack Data From Multiple Columns and Ignore Empty Cells

[barim]

I would like to have a formula to collect data into column A from columns B,C,D on the same worksheet. My problem is that there are a lot of blank cells. I would like to have all that data into one contiguous column such as column A. Is this possible to do?
Thanks.

 

[sandy666]

you can try PowerQuery (Get&Transform)

[SIZE=1]// Table1
let
    Source = Table.ToColumns(Excel.CurrentWorkbook(){[Name="Table1"]}[Content]),
    ToTable = Table.FromList(Source, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
    Expand = Table.ExpandListColumn(ToTable, "Column1"),
    FilterBlank = Table.SelectRows(Expand, each ([Column1] <> null))
in
    FilterBlank[/SIZE]