2 Replies Latest reply on Jun 10, 2012 4:10 PM by DKomjati

    How can I select rows of cells and merge them vertically into one cell in each column?

    DKomjati

      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 1Header 2Header 3Header 4Header 5Header 6
      10060030060020000120000




      2000
      5004005000010000
      5000


      3000


      200700
      67122600

      900



      100
      271231110






       

       

       

      Header 1Header 2Header 3Header 4Header 5Header 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