Append selected columns from multiple sheets into one sheet

Dear All,

I would like to append data from selected columns in multiple sheets (in the same workbook) into one sheet. Namely I would like to select the first three columns and the three last columns to be appended in one sheet (Master sheet or new workbook!)

I can append all the columns from all the sheets, but couldn't figure out how to select specific columns. and also have tried the consolidate and power query with no luck.

Thank you for your help in advance.

Regards,

Hi dacesexcel,

You totally write, and I though about it as well. I don't want to append all the columns and then delete the not required ones. I thought its better to only append the required columns.


Please see the attached dummy data. I would like my output the same as the data in the "Master" sheet

You can try this
The amount of Columns does not matter, the first 2 and the last 3

Please Login or Register  to view this content.