Populating one column with row data

[bton24]

I have a tough problem that I can't seem to figure out the formula for.
I am trying to populate a row of columns into one column in another sheet. The columns are populated with words. I'm trying to get the formula to read data in the first column, then when there is no data left, jump to the top of the next column. Then I'm trying to compile all of the data in the one column on a seperate sheet.
I am totally stumped! any help would be great. thanks

[starguy]

I have a tough problem that I can't seem to figure out the formula for.
I am trying to populate a row of columns into one column in another sheet. The columns are populated with words. I'm trying to get the formula to read data in the first column, then when there is no data left, jump to the top of the next column. Then I'm trying to compile all of the data in the one column on a seperate sheet.
I am totally stumped! any help would be great. thanks

would you please give some detail of your data with cell references where data resides.

Regards.

[Mallycat]

By row of columns, I assume you mean there are a number of columns next to each other.

This custom macro will do it for you. just click in the source range and then run the macro

Please Login or Register  to view this content.