Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-21-2014, 07:49 AM
Linh Linh is offline Delete empty cell and shift up Windows 7 32bit Delete empty cell and shift up Office 2007
Novice
Delete empty cell and shift up
 
Join Date: Sep 2014
Posts: 1
Linh is on a distinguished road
Default Delete empty cell and shift up


I have a table 2 columns x 3 rows that is populated with data from mailmerge. The data in columns are independent of the rows. If the cell is empty, I want to delete the empty cell and shift the data up for better presentation. Any idea? Pls see attached. I want to move the cell phone row up as well as the email cell up one row.
Attached Files
File Type: docx deleteCellShiftUp.docx (12.3 KB, 25 views)
Reply With Quote
  #2  
Old 09-21-2014, 01:52 PM
macropod's Avatar
macropod macropod is offline Delete empty cell and shift up Windows 7 64bit Delete empty cell and shift up Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

A mailmerge can't conditionally output table cells. Whole rows/tables, yes, but not cells within a row.

You could, of course, have multiple lines within a cell and have the mailmerge conditionally output/suppress those lines. Automating anything more complicated would require a macro.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Delete empty cell and shift up Macro to delete all empty rows from all tables braddgood Word VBA 15 10-02-2015 01:54 PM
Delete empty cell and shift up Unable to open or delete an empty folder Zimm Windows 4 11-19-2013 05:07 PM
Delete lots of empty space between paragraphs. FieldTechnician Word 4 10-25-2013 01:14 PM
Delete empty cell and shift up Macro to delete rows with all empty cells ubns Excel Programming 2 08-14-2012 02:01 AM
Delete empty cell and shift up Shift cell right gsrikanth Excel Programming 2 01-17-2012 11:29 PM

Other Forums: Access Forums

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


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