title: How to combine one row's data into a single cell using Openpyxl
body: <p>I have to combine 3 cells of a row separated by "-".</p>
  
  <p><strong>Input is:</strong></p>
  
  <pre><code>A1  A9  AMF
  A2  B9  BMF 
  A1  A9  AMF (Same as 1st row)
  A4  D9  DMF 
  </code></pre>
  
  <p><strong>Expected Output is:</strong></p>
  
  <pre><code>A1-A9-AMF
  A2-B9-BMF
  A4-D9-DMF
  </code></pre>
  
  <p>I have used the following, </p>
  
  <pre><code>for r1 in row:
      strcell1 = '-'.join(map(str,row)) # converting to string list
      cell1 = ''.join(strcell1)         # joining the cells
      list_value = [cell1]
      ws.append(list_value)            #writing on a different sheet of same workbook
  </code></pre>
  
  <p>But I am not getting the expected output, is there something that I am missing?</p>