Auto Fill X rows down depending on Number of rows in a table

I have four columns.

A B C D
Company Name Company Address Dr Name Dr Address

When I select a state from a drop down menu, a new set of data auto populates into this format. In this example, I have 32 company addresses and 15 Dr Names. What I need is to auto populate a new table that looks like this


E F

Company Address #1 Dr Address #1
Company Address #1 Dr Address #2
Company Address #1 Dr Address #3
Company Address #1 Dr Address #4
Company Address #1 Dr Address #5
Company Address #2 Dr Address #1
Company Address #2 Dr Address #2
Company Address #2 Dr Address #3
Company Address #2 Dr Address #4

And so on, until the table has gone through all 32 companies and compared them against the same 15 Dr Addresses


Can anyone help with this?

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown and reflect structure and type of data, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Here is some sample data. Hope this helps.

Hi, Markse! (and sandy666)

Please, check this file. Blessings!

Johnmpl,

This is fantastic. Thank you so much. I would have never arrived at this.

Mark