Combine Excel Sheets Into 1 New Excel File

Help Studio
1

Hi all,

I have an Excel Workbook with multiple sheets (amount of sheets & sheet names will vary each time). the structure of each sheet is the same (Same 4 columns, just different data):
image

What I’m trying to do is combine all of these sheets into 1 new Excel Workbook on 1 sheet, with just the headers at the top, and all of the data. So I want each sheet’s data to be copied below the last row on each sheet (no line breaks or spaces between):
image

I’ve tried doing this with Merge DataTable and Append DataTable, but no luck so far. Any suggestions would be appreciated!

1 Like
2

Hello,

You can use a get sheets , to get the list of sheets and loop in an array to merge . hold on let me send you a sample sequence

2 Likes
3

Hello @Luecke_Anthony, please find attached as promised MergeSheet.zip (16.8 KB)

4 Likes
4

Thanks @MasterOfLogic! This is exactly what I was looking for. I understand the logic now. :slight_smile:

1 Like
5

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