Sequencial Pairs on text and numbers

[jazzista]

Hello Forum. I have a list of invoices and dates and need a formula so that the formula creates a pair for each invoice and date. I have a list of invoices like this:

Inv#1
Inv#2
Inv#3
I need a formula that can do a pair like this from the list above:
Inv#1
Inv#1
Inv#2
Inv#2
Inv#3
Inv#3 .. and so on

Same with dates.
12/31/2017
01/31/2018
02/28/2018

I need a formula that can emulate the invoice pair as follows
12/31/2017
12/31/2017
01/31/2018
01/31/2018
02/28/2018
02/28/2018

My list has 2,000 lines and I don't want to copy , create a blank cell and paste the value.


Thanks in advance for any help

 

[Joe4]

Couldn't you just select the entire range all at once, and copy and paste it below the original range, then just sort your range to get it in that order?

 

[jazzista]

Joe4. Thanks. I will try the idea but I still a dynamic formula since I have just noticed that the pairs may vary to 2 or 4 pairs

 

[jazzista]

this is a large rebill to a partner in an oil well

 

[Joe4]

What actually determines/controls how many pairs there should be?

 

[jazzista]

by The expenses so if it has one expense it will have one line, if it has 2 expenses it will be 2 lines and so on....

 

[Joe4]

by The expenses so if it has one expense it will have one line, if it has 2 expenses it will be 2 lines and so on....

So, what does that actually look like (sorry, I having a hard time putting what you are saying with your original pictures)?
It may help if you can post a small example of the data you are starting with an your expected results, and we can clearly how to determine how may pairs are needed.
There is a tool that allows you to post screen images found here: XL2BB - Excel Range to BBCode

 

[DanteAmor]

I try to help ...
You got this

varios 09jul2020.xlsm
	A	B
1
2	Inv#1	12/31/2017
3	Inv#2	01/31/2018
4	Inv#3	02/28/2018
Source

Always repeat the line twice, then the result:

varios 09jul2020.xlsm
	A	B
1
2	Inv#1	12/31/2017
3	Inv#1	12/31/2017
4	Inv#2	01/31/2018
5	Inv#2	01/31/2018
6	Inv#3	02/28/2018
7	Inv#3	02/28/2018
Destination

Do you want that with a formula or can it be with a macro?

 

[jazzista]

DanteAmor. Thanks.. This is what I need? How can I extract the formulas? Again.. Many thanks

 

[jazzista]

JOE4. Here at work I cannot download anything and I need permission to download any app. That's why I put the example in text box so you have the idea of what i was trying to achive