Can someone help with a formula?

I want to generate multiple combinations of a set of data and am looking for
a formula to do it.

Data Set:

Segment Options Type Options Vendor Options Portfolio Options Country
Options Revenue Stream Options
XBX Esti DLL VJV BE IntrInc
FED Actl CIT MGD NL Xcharge
SMS Rvrs SVC ES BankInt
EPG Amrt AU BlndInc
MBS NZ OthrInc
OTH US
CA
UK
CH
DE
IT
FR
BR
JP

Combination Example for FED Segment:
(I want to keep the combinations in the following order)

Segment Type Vendor Portfolio Country Revenue Stream
FED Esti DLL SVC US IntrInc
FED Actl DLL SVC US IntrInc
FED Rvrs DLL SVC US IntrInc
FED Amrt DLL SVC US Xcharge