I have a scenario in which I need a formula for transposing 2 columns in
which 1st column contains one category (value) and its sub categories are
present in second column. The following will be the clear picture.

Like the following N no of categories, so I need a formula to transpose
based on the category.
E1 25
26
27
28
29
30
E2 31
32
33
34
35

I want the result in the following pattern.
E1 25 26 27 28 29 30
E2 31 32 33 34 35
Thanking you.