How would you normalize a database that has multiple products to a single transaction ID?
Might as well make my comment an answer so you can close it:

A Sales Order has many Sales Order Line Items. One table for Sales Orders, one for Sales Order Line Items with a foreign key to the former

create table sales_orders (
  id int primary key,
  order_date date,
  ...
);

create table order_items (
  order_id int references sales_orders(id),
  line_number smallint,
  unit_price decimal(19,4) not null,
  quantity smallint not null default 1,
  product_id int not null references products(id),
  ...

  primary key (order_id, line_number)
);