can someone proved me with vba code to concatenate all cells in a row to the last blank cell. Between each concatenation i would like a semicolon and blank space (; )
see the sheet provided in the link for my data example
Row 1 has one column with data.. Row 2 has 3 columns with data.. and so on..
I would like to concatenate all row columns with data into column A. Then repeat process to the final row.
see the sheet provided in the link for my data example
Row 1 has one column with data.. Row 2 has 3 columns with data.. and so on..
I would like to concatenate all row columns with data into column A. Then repeat process to the final row.
Mr Excel - Google Drive
drive.google.com