Merge multiple excel spreadsheets into one sheet

Help Studio
, ,
1

Hi, I have an excel with 5 different sheets. I want to merge these sheets to one excel sheet where some column names are different . for example, views, video views , total video views represent same thing . when I filter data table using required columns those are not merging properly as they are with different names(sheet1 has views, sheet2 has video views etc). my question is how to pull those columns data to one single column .

could you please suggest how I could solve this ?
Thanks in advance for help.

2

@haripriya_anumalasetty

Welcome to our UiPath community.

Can you rename column names video views and total videos from other sheets to views. So that column name will be same in all sheet. Then you can merge all sheets together.

3

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.