Hi there,
I have a list of companies in Excel and a proprietary formula that will pull in addresses for each of these companies. The problem is that the formula outputs the address of each company in three seperate rows and I need the each line of the address to display in a different column.
For example, the formula outputs:
5301 Stevens Creek Boulevard
Santa Clara, CA 95051
United States
And I need it to show:
5301 Stevens Creek Boulevard | Santa Clara, CA 95051 | United States
I don't know how to insert a macro myself, but if I had one that would insert two extra rows inbetween each company in my list and then would run my formula then another macro to transpose every group of three rows into three columns I think that would work.
Thanks
Bookmarks