Hi community,

Fist of all, sorry for my lack of proper terminology.

Working on Excel 2016, the sheet is 61 pages, each containing 41 rows and 12 columns from A to L (that is, 3 blocks of 4 columns each).

First, I need to orderly create a single block of 4 columns in every page.



Secondly, I want to merge all the 61 pages, now consisting each of a single block of 4 columns and 123 rows (41 rows x 3 blocks), into a single one containing 4 columns and 7506 rows (123 rows each page x 61 pages of the sheet).

This is what a typical row looks like, taking | as a separator for columns 正|改正|V|B|值|值得正|A|F|挚|真挚 A|B and they should become

正|改正 |V|B|

值|值得正|A|F|

挚|真挚 A|B|

I do not know whether Excel options enable getting the final result of a macro would make it easier.

Hope to hear news soon.
Thanks in advance.