Here is a VBA code that can help you too.ġ. In the formula, MyData is the range name you have specified in step 1. ![]() Then select a blank cell that you want place the results, enter this formula =INDEX(MyData,1+INT((ROW(A1)-1)/COLUMNS(MyData)),MOD(ROW(A1)-1+COLUMNS(MyData),COLUMNS(MyData))+1), press Enter key and drag fill handle down until an error displayed. Select the range you want to stack, and go to the Name Box to give this range a name, and press Enter key. Stack multiple columns into one with Transform Rangeġ. Stack multiple columns into one with formula In Excel, the Text to columns function can split a cell into multiple columns based on delimiter, but if there are any ways to stack multiple columns into one column as below screenshot shown? In this article, I will introduce some tricks on solving this task quickly. How to quickly stack multiple columns into one column in Excel?
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |