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