How to arrange column from Horizontal to Vertical

Or you can use Power Query (Get & Transform Data), if you have a later version of Excel:

let
    Source = Table.DemoteHeaders(Excel.CurrentWorkbook(){[Name="Table1"]}[Content]),
    Combine = List.Combine(Table.ToColumns(Source))
in
    Combine