I need help with logic to get the desired out from an excel sheet. I want the code to be dynamic so can handle 1 or 2 or 3 company names up to 10 maximum. Any help with be appreciated. Thank you in advance.
Expected Input:
Expected Output:
|Full Legal Name|Address Line 1|Address Line 2|City|State|Zip Code|Country|
|Robotics LLC|Suite 110|Green Park|Austin|Texas|21345|UNITED STATES|
|Robotics LLC|Suite 110|Green Park|Austin|Texas|21345|UNITED STATES|
|Robotics LLC|Suite 110|Green Park|Austin|Texas|21345|UNITED STATES|
|Robotics LLC|Suite 110|Green Park|Austin|Texas|21345|UNITED STATES|
|Robotics LLC|Suite 110|Green Park|Austin|Texas|21345|UNITED STATES|
|Robotics LLC|Suite 110|Green Park|Austin|Texas|21345|UNITED STATES|
|Robotics LLC|Suite 110|Green Park|Austin|Texas|21345|UNITED STATES|
|Robotics LLC|Suite 110|Green Park|Austin|Texas|21345|UNITED STATES|
|Robotics LLC|Suite 110|Green Park|Austin|Texas|21345|UNITED STATES|
|Robotics LLC|Suite 110|Green Park|Austin|Texas|21345|UNITED STATES|