Question
How can I select rows of cells and merge them vertically into one cell in each column?
I'm working in CS4 and need to be able to select 2 to 6 rows of cells (with many columns) in a table and then merge the selected cells vertically into one cell in each column. A few cells in the chart will not need to merge so I must select the ones that do. I have almost 100 pages of charts with cells that need merged this way by Tuesday. Please help!
Top chart example needs to change to the bottom example.
| Header 1 | Header 2 | Header 3 | Header 4 | Header 5 | Header 6 |
|---|---|---|---|---|---|
| 100 | 600 | 300 | 600 | 20000 | 120000 |
| 2000 | |||||
| 500 | 400 | 50000 | 10000 | 5000 | |
| 3000 | |||||
| 200 | 700 | 67 | 122 | 600 | |
| 900 | |||||
| 100 | 2 | 7 | 123 | 1110 | |
| Header 1 | Header 2 | Header 3 | Header 4 | Header 5 | Header 6 |
|---|---|---|---|---|---|
100 500 200 100 | 600 400 700 900 | 300 5000 30000 2 | 600 10000 67 7 | 20000 2000 122 123 | 120000 5000 600 1110 |
AdChoices