|
|
#1
01-07-2015, 10:50 PM
|
|||
|
|||
Merging Rows - HELP please!
I am working on a table in Excel and the data needs to be on one line where currently 3 columns are in one row and the remaining 3 columns are in the next row. It currently looks like this (See attachment). I am stumped. How can I accomplish this without doing it line by line manually for multiple rows?
It seems simple but it's problematic. I have too many rows in this table to do this manually for each pair of rows that should be one row. TIA!! P.S. I'd also like to drop off the % in rows 2009/2010 for the entire table. . . Last edited by MessyJessy; 01-07-2015 at 10:57 PM. Reason: Added more detail to the question 
|
| Tags |
| join, merge, rows |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Delete blank rows between the two rows that contain data
|
beginner | Excel Programming | 5 | 12-26-2014 12:29 AM |
|
Delete All empty Rows - Print - Undo all Rows deleted
|
Bathroth | Word VBA | 1 | 10-01-2014 01:40 PM |
|
Grouping table rows to prevent individual rows from breaking across pages
|
dennist77 | Word | 1 | 10-29-2013 11:39 PM |
|
Count rows and add blank rows accordingly
|
Hoochtheseal | Word VBA | 1 | 01-29-2013 09:23 PM |
|
merging rows and creating sub-rows
|
gib65 | Excel | 2 | 12-09-2011 02:09 PM |
Windows 7 64bit 
Office 2010 32bit
Threaded Mode