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
|