Excel formula for copy data from cells to antother cells-CodePudding

I need a excel formula for copy data from a column to another column with a conditional situation.
please see below picture:

I have two columns with eu and ru name. I want to copy "eu" data rows if the header of the first column is "eu" and if I change "eu" to "ru" all data in "ru" copy to the blue part.

CodePudding user response：

This can be done by a simple =IF(), is it not? Like in the example =IF(D1="eu",A2,B2), as in the following screenshot:

CodePudding user response：

If you are on Microsoft-365 then could try-

=FILTER(E2:F7,E2:F2=B1)