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.
Thanks.