Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 07-31-2018, 04:22 PM
jeffreybrown jeffreybrown is offline How to combine multiple rows in to one through an equation on EXCEL? Windows Vista How to combine multiple rows in to one through an equation on EXCEL? Office 2007
Expert
 
Join Date: Apr 2016
Posts: 673
jeffreybrown has a spectacular aura aboutjeffreybrown has a spectacular aura about
Default

There are multiple options...
  • A pivot table
  • The subtotal function

...but in the end, there isn't a one formula that could do it that I know of.

Actually, the best way to represent what you want is to attach a sample workbook with a before and after in-lieu of a picture.
Reply With Quote
 

Tags
combining multiple rows



Similar Threads
Thread Thread Starter Forum Replies Last Post
Combine rows in one where other column is not null Hanna Excel 0 04-28-2017 07:31 AM
How can I delete every 3rd row/add 'by'/combine ever two rows (besides doing it manually) rustywriter Excel 4 12-03-2016 04:39 PM
Macro to Combine Multiple Rows into One Row brunssl2 Excel Programming 10 01-13-2015 01:56 PM
How to combine multiple rows in to one through an equation on EXCEL? Combine multiple presentations stevevrabel PowerPoint 27 11-23-2014 07:42 AM
Combine or merge multiple worksheets into one worksheet timomaha Excel 1 07-21-2014 01:02 PM

Other Forums: Access Forums

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