what i need is vba code that will to concatenate all cells in a row to the last blank cell. the row data starts in column C (as in column C will always have a value) then repeat that step to the last row in a worksheet. I have a header row. i need the concatenated data to be in column B
example.. row 2 might have 5 columns with data, row 3 might have 1column with data, row 4 might have 10 columns with data, until last row.