Oracle 18c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table your_table (item_id, activity) as
select 1, 'In-Store' from dual
union all
select 1, 'Online' from dual
union all
select 1, 'Mall' from dual
union all
select 1, 'Shops' from dual
union all
select 2, 'Flagship' from dual
union all
select 2, 'Destination' from dual
6 rows affected

select item_id, activity,
  row_number() over (partition by item_id order by activity) as rn
from your_table


ITEM_ID
ACTIVITY
RN


1
In-Store
1

1
Mall
2

1
Online
3

1
Shops
4

2
Destination
1

2
Flagship
2


select *
from (
  select item_id, activity,
    row_number() over (partition by item_id order by activity) as rn
  from your_table
)
pivot (max(activity) for (rn) in (1, 2, 3, 4))


ITEM_ID
1
2
3
4


1
In-Store
Mall
Online
Shops

2
Destination
Flagship
null
null