Need help sorting data from 2 columns in multiple rows.

jaycethehuman · Sep 7th 2021

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)

**royUK** · Sep 7th 2021

You need to attach an example workbook, but reading your comments I would say that you need to rethink the layout of your data.

Working with data in Excel

jaycethehuman · Sep 7th 2021

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

**royUK** · Sep 7th 2021

That's an image not a workbook.

Devantes · Sep 8th 2021

Select a cell within the data.
Select Home > Sort & Filter. Or, select Data > Sort.
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.

**royUK** · Sep 8th 2021

Am I not clear, we need an example workbook.

Need help sorting data from 2 columns in multiple rows.

Participate now!

Share

Tags