SQL Server 2019

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

create table tblName (Name varchar(100),
Phones varchar(100),
Courses varchar(100));
insert into tblName values ('ABC','123,456','HTML,Java');
1 rows affected

insert into tblName values ('XYZ','321,654','PHP,CSS');
1 rows affected

SELECT Name, value phone, courses 
FROM tblName CROSS APPLY STRING_SPLIT(phones, ',');


Name
phone
courses


ABC
123
HTML,Java

ABC
456
HTML,Java

XYZ
321
PHP,CSS

XYZ
654
PHP,CSS


SELECT name, phone, value courses FROM
(SELECT name, value phone, courses 
FROM tblName CROSS APPLY STRING_SPLIT(phones, ',')) x
CROSS APPLY STRING_SPLIT(courses, ',')
ORDER BY name, courses, phone;


name
phone
courses


ABC
123
HTML

ABC
456
HTML

ABC
123
Java

ABC
456
Java

XYZ
321
CSS

XYZ
654
CSS

XYZ
321
PHP

XYZ
654
PHP

name	phone	courses
ABC	123	HTML
ABC	456	HTML
ABC	123	Java
ABC	456	Java
XYZ	321	CSS
XYZ	654	CSS
XYZ	321	PHP
XYZ	654	PHP