Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-16-2018, 07:54 PM
GEORGEJUNGCOCAINE GEORGEJUNGCOCAINE is offline merge blocks of columns into a single page Windows Vista merge blocks of columns into a single page Office 2007
Novice
merge blocks of columns into a single page
 
Join Date: Aug 2013
Posts: 6
GEORGEJUNGCOCAINE is on a distinguished road
Default

Quote:
Originally Posted by p45cal View Post
As a start
Yet, there's one more operation I need to carry out that I forgot to mention.

I need to divide into two those cells containing a string of Chinese characters follow by a string of Latin ones, which are separated by a space, so that each string of different scripts belong to a different column. These cells always appear in the second colum of a block of four columns.

Supposing one block of four columns, and four rows as a mere example
Captura.JPG



Finally, a new sheet/page of four columns, A-D, would contain all the fixed rows.

Here's the whole document I need to process elastic list.perpage50.xlsx

Please, notice the the last row of each page (number 42, except for the las page 61, which is number 6) just contains merged cells with the number of page, so these rows should not be taken into account, and if possible deleted.

I am afraid I am a newbie, so I trust your recommendations. I hope the whole process can be fully automated.

If any further clarification is necessary, please let me know.
Reply With Quote
Reply

Tags
blocks, order



Similar Threads
Thread Thread Starter Forum Replies Last Post
merge blocks of columns into a single page Writing in columns and text blocks Vazrael Word 9 08-19-2016 12:20 AM
Merge csv data onto one A4 page containing columns gerrymac Word 1 04-17-2016 02:32 PM
merge blocks of columns into a single page Mail merge conditional adress blocks. Thrizian Mail Merge 2 07-17-2012 10:41 PM
merge blocks of columns into a single page how to use Building Blocks or controls to add a page verbster Word 11 03-06-2011 04:05 PM
merge blocks of columns into a single page moving data from single to multiple columns? mzimmers Excel 3 08-23-2010 08:20 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:50 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft