| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
merging multple columns into one column (dynamically)
I am looking to merge multiple columns into one list. I have some code that will allow me to merge three columns into one list, but I am looking to be able to merge more than three. below is an example of what I am trying to do, and below that is the code that I am currently using for merging three columns.
list1 list2 List3 merged list AA AB AC AA AB AC =IFERROR(INDEX(List1, ROWS(D1:$D$1)), IFERROR(INDEX(List2, ROWS(D1:$D$1)-ROWS(List1)), IFERROR(INDEX(List3, ROWS(D1:$D$1)-ROWS(List1)-ROWS(List2)), ""))) + CTRL + SHIFT + ENTER |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Match a value to multple criteria both in rows and columns | Excel Worksheet Functions | |||
| Merging multiple columns of data into one column of data | Excel Discussion (Misc queries) | |||
| Sum columns dynamically | Excel Worksheet Functions | |||
| Macro to Combine 2 columns to make one column without merging | Excel Discussion (Misc queries) | |||
| How to lookup and sum multiple values based on multple columns | Excel Programming | |||
Threaded Mode
