How to edit New Table in edit query

[KL718]

I have table with (30K ROws, 30 Columns). I need 3 columns & all rows. I used New Table option with summarize option. Now I cannot edit it iin edit query.

What is the workaround. 

Current Data

Name  Code

X          [123,234]

r           [32,34]

If I used original table I can go into edit query & use split option, replace option & then unpivot to get below result. But If I create NEW table it does not allow to edit it.

output required

Name  Code

X         123

X         234

r          32

r  34

[v-chuncz-msft · Accepted solution]

@KL718 

Calculated tables created with DAX are not visible in the Query Editor. You may Reference queries in the Query Editor and change code in The Advanced Editor.

let
    Source = Table1,
    #"Removed Other Columns" = Table.SelectColumns(Source,{"Column1", "Column2"}),
    #"Removed Duplicates" = Table.Distinct(#"Removed Other Columns")
in
    #"Removed Duplicates"

[Anonymous]

Hey @KL718 

What is the source?
Is it SQL?
Why not query with relvant data only?

select col1, col2, colN from Table

Cheers!
A

[KL718]

Source is Excel file. I do not want to use original file since the output what i want will be moved from column to row level thus creating duplication for all 30 K rows & 30 columns which I do not want.

I just want to subset the data & oull only 3 columns & work on it.