ExcelBanter - Creating combinations

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Creating combinations (https://www.excelbanter.com/excel-discussion-misc-queries/165380-creating-combinations.html)

sweetas01

Creating combinations

I want to create combinations from the below variables (A1:A5 & X, Y and Z
being cell references). Is there a formula that will allow me to do this?

X Y Z
A1 A G M
A2 D G
A3 A D G
A4 I
A5 A I

All times are GMT +1. The time now is 05:40 PM.