title: How to write text file data into same cell of excel using bash
body: <p>I have a scenario where I want to redirect all the output of a text file into a single cell of excel.</p>
  
  <p>text file data:</p>
  
  <pre><code>"remove dead code" 
  "keep cassandra and postgres in OR condition"
  "InsertFailCDRList"
  "to be updated in error handling US, write TODO here in comments"
  </code></pre>
  
  <p>I want this data in my one column.
  For eg.</p>
  
  <pre><code>    C1             C2
      1            TEXT FILE OUTPUT HERE
      2            OTHER TEXT FILE OUTPUT HERE
  </code></pre>
  
  <p>But problem is text is not coming single cell but it spreads to multiple cells.</p>
  
  <p>Using commands:</p>
  
  <pre><code>#!/bin/bash  -x
  output=$(cat commentmessage.txt)
  number=1
  echo $number,"${output}" &gt; buc_review_comments_data3.csv
  </code></pre>
  
  <p>Output is like:</p>
  
  <pre><code>        C1             C2
           1            "remove dead code"
          "keep cassandra and postgres in OR coniditon"
          "InsterFailCDRList"
  </code></pre>
  
  <p>I want all under row 1 column 2. How can we do this using bash? Please help.</p>
  
  <p>Desired Output:</p>
  
  <pre><code>       C1                C2
          1            "remove dead code"
                       "keep cassandra and postgres in OR coniditon"
                        "InsterFailCDRList"
  
          2             "new data here"
                        "new data"
  </code></pre>
  
  <p><a href="https://i.stack.imgur.com/NnGyC.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/NnGyC.png" alt="Format required - this is result wanted"></a></p>
  
  <p>So Basically, I have 
  ID=BUC123  </p>
  
  <p>totalcomments=4</p>
  
  <p>Text file - containing multiple comments.</p>
  
  <p>Want these in above format in excel.</p>