How on work on these excel

Help Studio
, ,
1

i have 4 excels what i need to do is i need to append all excel one after the other but i dont need to add headers and need one empty row between each appended excel how to do it can any one help pleaese

i am adding the screenshoot that i need finally

image
image1366Ă—768 90.1 KB

2

Can you send the sample excel files?? @manoj2500

3

Good evening @manoj2500,

You can use the following steps to accomplish your goal:

  1. Read Range on Workbooks 1-4 (store in separate Data Tables).
  2. Use “Add Data Row” to add a blank row to DT1.
  3. Use “Merge Data Table” to append DT2 to DT1.
  4. Use “Add Data Row” to add a blank row to DT1.
  5. Use “Merge Data Table” to append DT3 to DT1.
  6. Repeat one last time for DT4.
1 Like
4

here is the sample files @Manish540
Sample File - 3.xlsx (44.4 KB)Sample File - 3.xlsx (44.4 KB) Sample File - 3.xlsx (44.4 KB) Sample File - 3.xlsx (44.4 KB)

5

but i dont want the headers from dt2 dt3 etc

6

There will only be one set of headers after merging the datatables.

1 Like