Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 02-28-2017, 11:15 PM
FUGMAN FUGMAN is offline eliminating blan rows between cells in a column cantaining data Windows 10 eliminating blan rows between cells in a column cantaining data Office 2016
Banned
eliminating blan rows between cells in a column cantaining data
 
Join Date: Feb 2017
Posts: 55
FUGMAN is on a distinguished road
Default eliminating blan rows between cells in a column cantaining data

The assistance I have previously received in this Forum has been excellent.
I am thanking you in advance for any assistance regarding the following issue.

I have a column consisting of predictable data categories such as the following:

Column "A"
aaaa
bbbb
cccc
dddd
eeee

Unfortunately, the data is available to me with an unknown number of blank rows separating them such as:

Column "A"


"aaaa"


"bbbb"
"cccc"

"dddd"




"eeee"

The number of blank rows is inconsistent from one source to the next. I would like a procedure that will eliminate any blank rows between the values "aaaa" through "eeee". In addition, the nature of the beast is such that filter sorting is not an option.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
eliminating blan rows between cells in a column cantaining data Merge duplicate rows but retain data from one column Willem113 Excel 1 09-21-2016 05:42 PM
eliminating blan rows between cells in a column cantaining data Macro for Column to Rows Data brunssl2 Excel Programming 3 04-28-2014 07:07 AM
eliminating blan rows between cells in a column cantaining data How to send several rows of data from one column to each recipient in one go mikustykus Mail Merge 14 09-30-2013 08:32 AM
eliminating blan rows between cells in a column cantaining data Eliminating zeros, null values and negatives in a column jannie Excel 1 06-22-2011 07:03 PM
Count range cells eliminating merge cells danbenedek Excel 0 06-15-2010 12:40 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:08 AM.


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