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]

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

OK. The part I am unsure of is regarding this statement:

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, trying to tie that back to the examples in you original post, what shows how many exenses it has?
I see invoice numbers, but in my dealings with Invoices, a single invoice may have multiple expense lines.

You must remember, while this problem is very familiar to you, all that we know about it is what you tell us. So it usually works best if you explain in great detail, as if you were showing someone who has never seen this before (because we haven't!). It helps to provide range details (what rows and columns your data appears in).

 

[DanteAmor]

This is what I need?

Are you asking me if that's what you need?
I definitely don't know.

How can I extract the formulas?

I have not put the solution, we just try to understand what data you have and what you want as a result.

I'm also worried, because you don't give more real examples. What do you mean with:

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....

You should put at least 3 examples:
1. " if it has one expense it will have one"
2. " if it has 2 expenses it will be 2 lines"
3. "and so on"