View Single Post
 
Old 07-10-2014, 12:32 PM
babs babs is offline Windows 7 64bit Office 2010 64bit
Novice
 
Join Date: Jul 2014
Posts: 3
babs is on a distinguished road
Default Combining Rows in Excel

I have seen similar posts to this, but none quite like what I need help with...

I have a sheet where each row is an agreement, but not every cell in that row has a value and information for one agreement could be spread out onto multiple rows. I want each unique agreement to have one row. In the attached sample you will see there are a lot of blank cells on each row and information for one agreement number could be spread out between about six lines. If I could get everything associated with the same agreement/sub number on one line and have the other ones removed that would be great! I feel like when I go through options in my head it becomes much more complicated than it should be! The current sheet I'm working from has about 23,000 lines in it, so this will be a huge help!
Attached Files
File Type: xlsx SampleData.xlsx (10.7 KB, 15 views)
Reply With Quote