Transpose coloumn to row skipping some values based on another cell

[alex0182828]

I need to transpose column A but skip fields that have the value 'Legacy' in column d

I.e transposed row shoud not have 'colour' in it.

Thanks heros

 

[ExcelToDAX]

How about:

=LET(RemovedLegacy,INDEX(FILTER(A2:D13,D2:D13<>"Legacy"),,1),FILTER(RemovedLegacy,RemovedLegacy<>"Colour"))

 

[JamesCanale]

=TRANSPOSE(FILTER(A2:A13,D2:D13<>"Legacy"))

 

[Fluff]

Another option

=TOROW(FILTER(A2:A100,D2:D100<>"legacy"),1)