title: Concatenate range of cells with criteria in a column
body: <p>I need help with vba concatenate cells.</p>
  
  <p>I have a spread sheet:
  column A contain values like Product A for a few rows, Product B for a few rows, and so on.
  I want to concatenate, say cells in columns B-J for Product A, write the value to column K or another sheet, then do the same thing with Product B, and so on till the end of the spreadsheet. </p>
  
  <p>I think this would need some vba coding which I am learning but not good yet to do the job. Please help!</p>
  
  <p>Thank you,
  cj</p>