Hello,
I have a sample excel data set below:
| Customer # | Name | Address | 
| 1 | John | 123 Main St | 
| 2 | Joe | 321 Main St | 
| 3 | Alex | 456 Main St | 
I also have a static reference excel file with information that is specific to the above data set, but not specific to a certain customer.
| Store City | Branch # | 
| Miami | 501 | 
What is the best way to bring the static reference data and repeat it for each customer so the output is like the below:
| Customer # | Name | Address | Store City | Branch # | 
| 1 | John | 123 Main St | Miami | 501 | 
| 2 | Joe | 321 Main St | Miami | 501 | 
| 3 | Alex | 456 Main St | Miami | 501 | 
Thank you!
Solved! Go to Solution.
Thank you!!
 
					
				
				
			
		
