LinkBack URL
About LinkBacks
Hello. I have numbers in a bunch of adjacents rows but the column length is different. For example two numbers, five numbers (in seperate cells) etc. How can I easily combine all of these numbers into one long column? Macro or regular excel.
Hello. I have numbers in a bunch of adjacents rows but the column length is different. For example two numbers, five numbers (in seperate cells) etc. How can I easily combine all of these numbers into one long column? Macro or regular excel.
For that you use something like this:
Formula:
Please Login or Register to view this content.
Adjust the cells to needs and you can have any number of cells in it.
Cheers!
Tsjallie
--------
If your problem is solved, pls mark the thread SOLVED (see Thread Tools in the menu above). Thank you!
If you think design is an expensive waste of time, try doing without ...
Assume your first column of Data is Column A, then
Please Login or Register to view this content.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
This doesn't work. Spreadsheet attached.
This will combine the 4 columns that you have eliminating all blank cells:
This is an ARRAY FORMUL so enter with Ctrl + Shift + Enter
Formula:Please Login or Register to view this content.
Last edited by newdoverman; 05-05-2015 at 03:27 PM.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks