How to concat common rows in excel file and and write into single cell

Help Studio
, ,
9

Another method to solve the issue.

  1. Read files to separate data tables.

  2. Than use Merge Data Table activity.

  1. Use remove Remove Duplicate Rows (optional).
  1. Write data table to a new Excel file.