hi @candyspecs , welcome to the community!
you may have a look here: Pulling in data for specific column from multiple tables - #10 by Christiaan_Huizer
it shows how you can combine data using listcombine with the column type select list
I hope it helps, cheers, christiaan