<div>
The file is missing..can you post your file with desired results what you are looking for..
</div>


The file is missing..can you post your file with desired results what you are looking for..

ee-URL-CoName-split.xlsx

<div>
<div class="content wysiwyg-content">
i have many columns of all varying length<br />
<br />
i need the values in each column to be appended into COL A &nbsp;and B but in a sequence<br />
-col a having url<br />
col b having all company names<br />
<br />
so my data is url in one column then company name in another , url #2 company name #2 in next two columns, #3 in next two<br />
<br />
thanks if anyone has ideas can help/ file attached as example<br />
<br />
i attached the book
</div>
</div>


i have many columns of all varying length

i need the values in each column to be appended into COL A  and B but in a sequence
-col a having url
col b having all company names

so my data is url in one column then company name in another , url #2 company name #2 in next two columns, #3 in next two

thanks if anyone has ideas can help/ file attached as example

i attached the book

excel combine columns into two

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Cascading Style Sheets (CSS) is a language used for describing the look and formatting of a document written in a markup language. Usually used to change web pages and user interfaces written in HTML, it can also be applied to any kind of XML document. CSS is designed primarily to distinguish the content of a document from its presentation.

VBScript (Visual Basic Scripting Edition) is an interpreted scripting language developed by Microsoft that is modeled on Visual Basic, but with some important differences. VBScript is commonly used for automating administrative and other tasks in Windows operating systems (by means of the Windows Script Host) and for server-side scripting in ASP web applications. It is also used for client-side scripting in Internet Explorer, specifically in intranet web applications.