how can I automatically copy data from multiple columns on a tab and paste it on a single column on-CodePudding

I am trying to find a formula that I can copy the data from columns H to Q on "Master" sheet

and paste it into column D on another tab ("Sheet1") in the same workbook

CodePudding user response：

Use TOCOL() function. Put below formula to Sheet1 D2 cell.

=TOCOL(Sheet2!H2:Q50000,1)

CodePudding user response：

You can use VSTACK to pull all the columns from one sheet into a single column in another sheet. If you don't want blanks you can combine VSTACK and FILTER. I made a quick set of sample data to mimic what you posted, below. Then used the VSTACK and FILTER functions to pull it into one column. Modify as needed to pull into new spreadsheet.