How can I bring back the table I had before I grouped two columns?

[Anonymous]

I want to see the original table and the new columns that got grouped. I'll appreciate the help, thank you.

[Anonymous · Accepted solution]

Hi @Anonymous ,

Just the name of the table(Step name), which is equal to the name of the query from which the table is the result.

If the name of the query (table) contains spaces or other special characters, the name must be included in #"....",
e.g. #"Table name".

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

That table can always be referred to by its step name, like

= TheStepNameBeforeTheGroupStep

or like

= Table.Join(PriorStep, {"Column"}, StepNameBeforeTheGroup, {"Column"}, JoinKind.Whatever)

--Nate