denormalize transaction data