I would like to know how to transpose automatically (if vba, no button) the data of 10 identic tables (B5:E100) in the same excel file into one central table on the last sheet (Sheet 11), without taking into account the empty lines.
I would like to know how to transpose automatically (if vba, no button) the data of 10 identic tables (B5:E100) in the same excel file into one central table on the last sheet (Sheet 11), without taking into account the empty lines.