Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 04-01-2018, 12:54 PM
NoSparks NoSparks is offline Displaying Data from rows in fewer Colomns Windows 7 64bit Displaying Data from rows in fewer Colomns Office 2010 64bit
Excel Hobbyist
 
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 842
NoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of light
Default

What you're saying and showing is rather vague.

What's the logic to this ?
Why duplicates?
Why 3 rows for A1 and 2 for A2 ?
Why blank rows between the A1's and not the A2's ?
How many columns are actually in each table ?
Are these tables true Excel tables or standard ranges ?
What are the headers ?
Where on what sheet does the original data exist ?
Where are you wanting the results to be placed ?

How about attaching a workbook with sample data showing what you are really starting with and what you really want to end up with.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel Worksheet is not displaying data and rows are changing to 409.5 height instead of the 13.5 needexcelhelp Excel 1 06-18-2017 12:48 PM
Formatting data in scattered rows into rows following each other MorneDJ Excel 3 12-10-2016 12:35 AM
Displaying value according to selected data jimmy2016 Excel 2 09-29-2016 12:19 AM
Displaying Data from rows in fewer Colomns Delete blank rows between the two rows that contain data beginner Excel Programming 5 12-26-2014 12:29 AM
Displaying data graphically kylerickards Excel 0 05-05-2011 10:54 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:05 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