Dynamic Range Expansion (No VBA)

[sooshil]

Hi

I want to dynamically expand my data as follows without using VBA.

I have text data in a single column. There is no empty cells in between the data but the number of rows having data can vary.

Names

John

Sam

Jessica

<tbody>
</tbody>

I want my result as follows.

Matches

John Vs Sam

John Vs Jessica

Sam Vs Jessica

<tbody>
</tbody>

If I add one more data:

Names

John

Sam

Jessica

Peter

<tbody>
</tbody>

I want my result updated automatically as follows.

Matches

John Vs Sam

John Vs Jessica

John Vs Peter

Sam Vs Jessica

Sam Vs Peter

Jessica Vs Peter

<tbody>
</tbody>

Any help would be highly appreciated. But, again, only Formulas, NO VBA.
Thank you.

 

[Fazza]

And they're not as old as me‼

I must find the time/interest to start using Power Query on day.

Keep promoting it, Sandy. Hope you have more success than I have with MS Query (promoting, that is).
Both awesome tools and too little known.

As I like to say, a little SQL can do a lot of heavy lifting.

 

[sandy666]

SQL? 70's
Honestly, Power Query is the successor of MS Query but it is known that MS is not too fast in implementing anything so PQ took a long time so I will not write anything about promotion, it's a bad for health

 

[sooshil]

Thank you so much all of you for this nice conversation.
Yeah, the second query of Fazza solves my problem exactly as I wanted to. Thank you.

God bless you.