Get custom columns from Filter function

[Juniad]

I have attached sample file where required the 1st,2nd,3rd and 7th Column through Filter function.

 

[Khalid NGO]

Hi,

Power Query if interested:

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"File No", type text}, {"Name", type text}, {"Designation", type text}, {"Status", type text}, {"Passed Date", type any}, {"Card Status", type text}, {"Card Received", type text}}),
    #"Removed Other Columns" = Table.SelectColumns(#"Changed Type",{"File No", "Name", "Designation", "Card Received"}),
    #"Filtered Rows" = Table.SelectRows(#"Removed Other Columns", each [Card Received] <> null and [Card Received] <> "")
in
    #"Filtered Rows"

Regards,

 

[Peter Bartholomew]

Using dynamic arrays
= FILTER( Table1[[File No]:[Designation]], Table1[Card Received]<>"" )
= FILTER( Table1[Card Received], Table1[Card Received]<>"" )

 

[Fluff13]

Another option
=FILTER(FILTER(A1:G18,(COLUMN(A1:G1)<4)+(COLUMN(A1:G1)=7)),G1:G18<>"")

 

[deciog]

Fluff13

I liked it very good logic

Decio

 

[Fluff13]

Cheers