EXX-131007-2-Column-Table.docx

<div>
Perfect - was much simpler to use columns - thank you
</div>


Perfect - was much simpler to use columns - thank you

<div>
<div class="content wysiwyg-content">
Dear Experts<br />
<br />
In word, using VBA, I need to split the contents of a table into two columns and repopulate.<br />
<br />
The table has a header row &quot;Company&quot; and may list anything from 1 to 100 companies in the proceeding rows (These are already sorted into alphabetical order). Both columns need to have the Company header title in them. <br />
<br />
So the logic for 10 companies listed would be...<br />
<br />
There are 11 rows (10 + the header) - this would be split into 2 columns of 6 rows (5 companies + the header in each)<br />
<br />
If there is an odd number of companies listed (say 9) then the second column would have a blank cell at the end so the number rows would be 5 &amp;&nbsp;5 (column 1 = header row + 5 companies, column 2 = header row + 4 companies + blank cell)<br />
<br />
I'm thinking the easiest way to do this is to create a new table underneath, populate it and then delete the original table<br />
<br />
The original table has been generated by exporting a query in MS Access to an RTF document. &nbsp;If it’s easier then I’m sure I can do the count of the listed companies in Access.<br />
<br />
Can anybody help?
</div>
</div>


Dear Experts

In word, using VBA, I need to split the contents of a table into two columns and repopulate.

The table has a header row "Company" and may list anything from 1 to 100 companies in the proceeding rows (These are already sorted into alphabetical order). Both columns need to have the Company header title in them. 

So the logic for 10 companies listed would be...

There are 11 rows (10 + the header) - this would be split into 2 columns of 6 rows (5 companies + the header in each)

If there is an odd number of companies listed (say 9) then the second column would have a blank cell at the end so the number rows would be 5 & 5 (column 1 = header row + 5 companies, column 2 = header row + 4 companies + blank cell)

I'm thinking the easiest way to do this is to create a new table underneath, populate it and then delete the original table

The original table has been generated by exporting a query in MS Access to an RTF document.  If it’s easier then I’m sure I can do the count of the listed companies in Access.

Can anybody help?

Split word table into 2 columns

Microsoft Word is a commercial document editing program that is part of the Microsoft Office suite. It features numerous text-editing tools for creating richly formatted documents, along with tools for the use of macros in Word documents. Word's native file formats are denoted either by a .doc or .docx file extension. Plugins permitting the Windows versions of Word to read and write formats it does not natively support, such as the OpenDocument format (ODF) are available. Word can import and display images in common bitmap formats such as JPG and GIF. It can also be used to create and display simple line-art.

Microsoft Word

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.