hey experts, here is the problem:
I have a bunch of data mapped out in excel. Prior to creating a table, I have a bunch of data, one column is normal, the other column is spread across 8 cells and all of the cells are merged. So this second cell is spread across the whole page.
I NEED to make this thing into a table. When I go to Format as table, it turns my second column (made of merged cells) into 8 columns.
If I delete the unnecessary ones, then the column in the table is now really tiny, and I can't expand it without expanding the column for the entire spreadsheet.
How can I merge columns IN A TABLE? (note: Excel 2007)