combine multiple fields from one table into one main field


hi everyone!

I'm working with a dataset in which every new transaction creates a new 'transaction date' field as oppose to keeping the dates within one field. see sample attached. I'm trying to figure out how to combined the fields 'transaction 1 date' thru whatever the number of transactions may be, into just one 'transaction date' field. any ideas? i appreciate any help. thanks,