Creating a combination list with using 2 lists

**neutral5** · 07-27-2019, 10:59 AM

Screenshot_1.jpg

How can I create "Final" list with using "List 1" and "List 2"? I created "Final" list manually, just to show what I want.

**alansidman** · 07-27-2019, 11:21 AM

Here is a VBA solution

Please Login or Register  to view this content.

**Bo_Ry** · 07-27-2019, 11:39 AM

Please try at D2

=IF(ROWS(D$2:D2)>COUNTA(A$2:A$9)*COUNTA(B$2:B$9),"",INDEX($A$2:$A$9,ROUNDUP(ROWS(D$2:D2)/COUNTA($B$2:$B$9),))&INDEX($B$2:$B$9,MOD(ROWS(D$2:D2)-1,COUNTA($B$2:$B$9))+1))

Creating a combination list with using 2 lists

LinkBack

Thread Tools

Rate This Thread

Display

Creating a combination list with using 2 lists

Re: Creating a combination list with using 2 lists

Re: Creating a combination list with using 2 lists

Thread Information

Users Browsing this Thread

Similar Threads

Creating Sub-Lists from 1 Primary List

[SOLVED] Picking Different Items Between Two Lists and Creating a New List

Creating dependent lists on the first list

Creating Smaller Lists from a Big List

Data Validation Lists - Creating lists based on data from another list

Creating a list of numbers based on two other lists

Lists/drop downs creating more than one sub list?

Bookmarks

Bookmarks

Posting Permissions