i have 1000 tables in one sheet the tables have same amount of data ie each table have 6 column and 48 rows each table is below other table.
I want to transpose all tables through macro and result in same sheet or next sheet.