Hi,
I've an excel file in which a few sheets are present. I've to copy the data in the sheets excluding the headers (Header is marked with Yellow Color in each sheet) to a format called Wardwise.
Please refer to the attached sheet.
I've to copy the data in Column B in the Sheet 98 to Column B in the Sheet in Wardwise. Then I've to copy and paste below the data in Column B in the Sheet 100 to Column B in the Sheet in Wardwise. Then I've to copy and paste below the data in Column B in the Sheet 101 to Column B in the Sheet in Wardwise.

Then I've to insert a column called Part and paste the sheet numbers (Name of the sheet). ie for the data in the sheet 98, 98 has to be pasted and for the data in the sheet 100, 100 has to be pasted and then for the data in the sheet 101, 101 has to be pasted.

Then remaining columns in each of the sheet has to be copied to the sheet Wardwise as it is.

Then the sheet Ward wise has to be sorted thorugh Columns D,C & B respectrively.

Attached Files

Pattadaikatti-Merge-Test.xlsx (180.8 KB, 7 views)

Use Power Query to append each sheet to each other and then Close and Load to your desired location.

https://www.youtube.com/watch?v=zAmP-t_Q2L0

__________________
Alan עַם יִשְׂרָאֵל חַ Using O365 v2505

@rtr1811
Please let us know if your problem is solved. Thanks

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post