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