# Need help sorting data from 2 columns in multiple rows.

• Hello ,
I would love some help with the following problem.
I have two columns with multiple data. something like

 A xx B xy C xds D xsd E 124 E 235 F 163 F 643 A ab B abc C abds D asd E 124 E 152 E 236 E 235 F 164 F 667

And i want to make a transpose out of it. I have to mention that there is a empty row between every set of data and the hard thing for me is the variable number of E's and F's column for every set. let's say that in a set there are 5 F data, in a set 3 and so on (max 10)
is there a way I could have t in the following format?

 A B C D E F xx xy xds xsd 124 163 xx xy xds xsd 235 643 xx xy xds xsd xx xy xds xsd ab abc abds asd 124 164 ab abc abds asd 152 667 ab abc abds asd 236 ab abc abds asd 235

Thanks and apologies for broken language (not my primary language)

• Something like this.

I have column A and B and want to transpose them in something like that. Every series of data is delimited by an empty row. and I have hundreds of series of data with variating number of E and X (just line in imagine) but not more than 10(E and x) per series

## Images

1. Select a cell within the data.
2. Select Home > Sort & Filter. Or, select Data > Sort.
3. Select an option: Sort A to Z - sorts the selected column in an ascending order. Sort Z to A - sorts the selected column in a descending order.