Can we merge excel cells using process studio?
Though we do not have any direct step to merge cells of Excel in Process Studio, we can make use of Macro Code and VB script executor to execute the Macro Code.
Hi @sagar.bhandare You can have 2 Excel Inputs steps that read 2 different files, and use some Merge Steps like MultiWay Merge. But remember you must have a Key Column to relate the data.
Or if you want just to join 2 different files with no logical relations, just use Write Excel.
