SELECT Receivers FROM myTableUNIONSELECT Payers FROM myTable
--Setup Sample Datadeclare @transactions as table (Receivers char(1), Payers char(1))insert into @transactions(Receivers, Payers)values('A' , 'A'),('B' , 'A'),('A' , 'B'),('A' , 'D'),('B' , 'D'),('C' , 'A'),('B' , 'E'),('A' , 'E')--Actual work statementselect distinct [Group]from ( select Receivers [Group] from @transactions union all select Payers [Group] from @transactions ) c
declare @transactions as table (Receivers char(1), Payers char(1))insert into @transactions(Receivers, Payers)values('A' , 'A'),('B' , 'A'),('A' , 'B'),('A' , 'D'),('B' , 'D'),('C' , 'A'),('B' , 'E'),('A' , 'E')SELECT RecPyrFROM @transactionsCROSS APPLY (VALUES (Receivers),(Payers)) a(RecPyr)GROUP BY RecPyr