Combine data from multiple excel sheets when data and header is starting from row#8

There are several tabs in my Excel sheet, I have to combine data from three tabss(Flow 1, Flow 2 & Flow 3) but the row header and data is starting from row #8. All headers are same except for one column(solumn S) which is same as tab name. Can you please help me solve this issue? I have attached sample workbook for your reference

Combine Files (2).xlsx

Developer

Input

Output

Tips and Tricks

Macros

Best Practices

Transformation

Accepted answers

OTrieger

@naveennandigam

You can use Batch Macro to solve this issue, and of course as this is a xlsx file you an indicate from which row the data starts. Do not need to worry about column S as it will create for you 3 hears for the 3 different names.

All comments

OTrieger

TUSHAR050392

Hey @naveennandigam My first suggestion will be to go with what @OTrieger has mentioned but if you are not familiar with batch macro, you can read data from those tabs individually and then union the data.

naveennandigam

Thank you @OTrieger for your response. I could load the data from the tabs, but I couldnt figure out how I set the header to specific row number. Could you please help me?

Combine Files Workflow.yxmd

naveennandigam

Thank you @TUSHAR050392 for your suggestion. There are more than 3 tabs for me to combine, Having a input for each tab and joining them later doesnt work

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703