How change way to show separated ranges Sideways instead of bottom

[maghari]

Hello,
I would thank jindon to help me in previous thread.
I would change way of showing data Sideways instead of bottom for all of ranges are existed in EXTRACTION sheet.I put what I would in change sheet.
will be many ranges in EXTRACTION sheet not only three ranges will increase ranges
thanks

[Aussiebear]

Have you considered the Excel function "Transpose"?

[jindon]

output data by showing horizontally across files | MrExcel Message Board (https://www.mrexcel.com/board/threads/output-data-by-showing-horizontally-across-files.1272735/)

1) This means to me that you don't like the code I posted.
2) You are still using that abbreviation for Japan.

So, don't expect me to help you more.

[maghari]

1) This means to me that you don't like the code I posted.
indeed I would your code you posted , but I need also this way.

2) You are still using that abbreviation for Japan.

my apologies again !
I would edit but I can't because edited is not allowing here.

[maghari]

Have you considered the Excel function "Transpose"?
not really sure works with my project.

[maghari]

posted
https://www.excelforum.com/excel-programming-vba-macros/1435298-how-change-way-to-show-separated-ranges-sideways-instead-of-bottom.html#post6027802