Transpose Issue

[ajmraghu]

Could you help me on this  Transpose issue in excel

Have attached a sample data

There are two columns – Zone & Region

Now need to Transpose (or you may call something else also) – this data Horizontally – Zone wise

Under each zone – the respective Regions need to appear

[#2]

@ajmraghu 

If you are on latest Excel, column names could be received by

=TRANSPOSE(SORT(UNIQUE($A$3:$A$144)))

and columns as

=SORT(FILTER($B$3:$B$144,$A$3:$A$144=E$2))

Alternative solution with Power Query

let
    Source = Excel.CurrentWorkbook(),
    OriginalData = Source{[Name="OriginalData"]}[Content],
    GroupRows = Table.Group(
        OriginalData,
        {"Column1"},
        {{"Lists", each List.Sort([Column2])}}
    ),
    Dotable = Table.FromRows(
        List.Zip(GroupRows[Lists]),
        GroupRows[Column1]
    )
in
    Dotable

Could be done with traditional formulas as well, but that's more time consuming.