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?