Hi all,
I have 20 sheet in the Excel file. in the below Format.
i want collate all the sheet in to 1 sheet.
I have 20 sheet in the Excel file. in the below Format.
i want collate all the sheet in to 1 sheet.
Excel Workbook | ||||||||
---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | |||
1 | country | movie | movie | therate | suma | time | ||
2 | usa | aaa | aa | a | a | a | ||
3 | usa | aaa | aa | a | a | a | ||
4 | usa | aaa | aa | a | a | a | ||
5 | usa | aaa | aa | a | a | a | ||
6 | usa | aaa | aa | a | a | a | ||
7 | usa | aaa | aa | a | a | a | ||
8 | usa | aaa | aa | a | a | a | ||
9 | usa | aaa | aa | a | a | a | ||
Sheet1 |