SQL Server 2019

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table tbl
(
    Product varchar(2),
    StartPoint char,
    EndPoint char
);
insert into tbl values
('P1', 'A', 'B'),
('P1', 'B', 'C'),
('P1', 'C', 'D'),
('P1', 'D', 'E'),
('P1', 'E', 'F'),
('P2', 'P', 'Q'),
('P2', 'Q', 'R'),
('P2', 'R', 'S'),
('P2', 'S', 'T');
9 rows affected

with rcte as
(
    select Product, t.StartPoint, t.EndPoint, path = 1
    from   tbl t
    where  not exists
           (
               select *
               from   tbl x
               where  x.Product = t.Product
               and    x.EndPoint = t.StartPoint
           )
           
    union all
    
    select t.Product, t.StartPoint, t.EndPoint, path = path + 1
    from   rcte r
           inner join tbl t on  t.Product    = r.Product
                            and t.StartPoint = r.EndPoint
)
select Product, [1] as [PP1], [2] as [PP2], 3 as [PP3], [4] as [PP4], [5] as [PP5], [6] as [PP6], [7] as [PP7]
from
(
    select Product, Point = StartPoint, path
    from   rcte
    
    union all
    
    select Product, Point = EndPoint, path + 1
    from   rcte r
    where  not exists
           (
               select *
               from   tbl x
               where  x.Product = r.Product
               and    x.StartPoint = r.EndPoint
           )
) d
pivot
(
    max(Point)
    for [path] in ([1], [2], [3], [4], [5], [6], [7])
) p


Product
PP1
PP2
PP3
PP4
PP5
PP6
PP7


P1
A
B
3
D
E
F
null

P2
P
Q
3
S
T
null
null