Probably an easy thing to do - filter and extract data from columns to another sheet

Originally Posted by AlKey

Try these array (Ctrl+Shft+Enter} formuals

In D2 and drag it to the right one field and down

For X

=IFERROR(INDIRECT(CHAR(65+COLUMN(A2))&SMALL(IF($A$2:$A$7="X",ROW($A$2:$A$7),""),ROWS($A$2:A2))),"")

For Y

In G2 and drag it to the right one field and down

=IFERROR(INDIRECT(CHAR(65+COLUMN(A2))&SMALL(IF($A$2:$A$7="Y",ROW($A$2:$A$7),""),ROWS($A$2:A2))),"")

	A	B	C	D	E	F	G	H
1				X			Y
2	X	1	4	1	4		2	6
3	Y	2	6	2	1		5	6
4	X	2	1	4	2		7	8
5	Y	5	6
6	Y	7	8
7	X	4	2

Hello and thank you for the quick reply! It works fine when I try it on a blank sheet but I want to adapt an existing sheet.
In the table I'm trying to sort, they're not X and Y but numbers that I want to extract. My guess is that I need to adapt the CHAR(65 + ...) in your formulas (as well as the "="X""). Would you mind explaining these to me so I can adapt them?

Thanks again!

Originally Posted by FDibbins

here is another option (prefer AlKey's suggestion though)...

Hi and thank you also for your quick reply

I'm having an issue with that option too: In my sheet there is a column between columns A and B of your sheet so your formula

=IFERROR(INDEX(C$2:C$7;MATCH(ROWS($A$1:B1);D$2:D$7;0));"")

located in H2 isn't doing the trick for me.

I tried to replace the "ROWS($A$1:B1)" by something like "ROWS($A$1;C1)" (to ignore the B column) but that, as you probably figured, doesn't work. Is there an elegant way of changing the formula? Else I could just copy my data so that I have nothing between the two

Thanks again!

Originally Posted by AlKey

Unfortunately, you never provided us with the correct ranges in your requirements. So, the examples that were given to you simply reflect an idea of how this should work. I hope you would agree that we simply can't read someones mind.

I totally agree with you. I "simplified" the example because I didn't want to just upload my sheet and let you guys do all the work. I thought that was a more appreciated way of asking for help in forums. I guess I was too vague, sorry about that.

In the end your solution is working for me. I simply used a "transition table" where I pre-sorted my data to make your formulas work. My apologies again if I made you feel like you wasted time, that was not my point at all!