Repeat column and multiply

Question

by power query, I'll give an example of the tables:

Table 1

Name

Adam

Frank

Thomas

I need an M formula to add a second column that repeats all the names for each name in column 1 except itself, so it looks like this:

hotchilli · Accepted Answer

Add a custom column:
List.RemoveItems(thePreviousStepName[Name], {[Name]})
then Expand the column 'To Rows'

Forum Discussion