SQL Server 2022

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

CREATE TABLE your_table (
  id                INT,
  name              CHAR,
  t1                INT,
  t2                INT,
  t3                INT,
  fullT             VARCHAR(11)
)
INSERT INTO
  your_table
VALUES
  (1, 'A', 59,	null, null, '59'),
  (2, 'B', 59,	20,   null, '59.02'),
  (3, 'C', 59,	40,   null, '59.04'),
  (4, 'D', 59,	60,   null, '59.06'),
  (5, 'E', 59,	60,   01,   '59.060.01'),
  (6, 'F', 59,	60,   10,   '59.060.10')
6 rows affected

WITH
  name_lookup AS
(
  SELECT
    id,
    name,
    t1, t2, t3,
    FIRST_VALUE(name) OVER (PARTITION BY t1         ORDER BY t1, t2, t3)  AS name1,
    FIRST_VALUE(name) OVER (PARTITION BY t1, t2     ORDER BY t1, t2, t3)  AS name2,
    FIRST_VALUE(name) OVER (PARTITION BY t1, t2, t3 ORDER BY t1, t2, t3)  AS name3
  FROM
    your_table
)
SELECT
    id,
    name,
    t1, t2, t3,
    CASE WHEN t1 IS NOT NULL THEN name1 END   AS name1,
    CASE WHEN t2 IS NOT NULL THEN name2 END   AS name2,
    CASE WHEN t3 IS NOT NULL THEN name3 END   AS name3
FROM
  name_lookup
ORDER BY
  id


id
name
t1
t2
t3
name1
name2
name3


1
A
59
null
null
A
null
null

2
B
59
20
null
A
B
null

3
C
59
40
null
A
C
null

4
D
59
60
null
A
D
null

5
E
59
60
1
A
D
E

6
F
59
60
10
A
D
F


WITH
  name_lookup AS
(
  SELECT
    id,
    name,
    t1, t2, t3,
    MAX(CASE WHEN t2 IS NULL THEN name ELSE NULL END) OVER (PARTITION BY t1        )  AS name1,
    MAX(CASE WHEN t3 IS NULL THEN name ELSE NULL END) OVER (PARTITION BY t1, t2    )  AS name2,
    MAX(                          name              ) OVER (PARTITION BY t1, t2, t3)  AS name3
  FROM
    your_table
)
SELECT
    id,
    name,
    t1, t2, t3,
    CASE WHEN t1 IS NOT NULL THEN name1 END   AS name1,
    CASE WHEN t2 IS NOT NULL THEN name2 END   AS name2,
    CASE WHEN t3 IS NOT NULL THEN name3 END   AS name3
FROM
  name_lookup
ORDER BY
  id


id
name
t1
t2
t3
name1
name2
name3


1
A
59
null
null
A
null
null

2
B
59
20
null
A
B
null

3
C
59
40
null
A
C
null

4
D
59
60
null
A
D
null

5
E
59
60
1
A
D
E

6
F
59
60
10
A
D
F


Warning: Null value is eliminated by an aggregate or other SET operation.

id	name	t1	t2	t3	name1	name2	name3
1	A	59	null	null	A	null	null
2	B	59	20	null	A	B	null
3	C	59	40	null	A	C	null
4	D	59	60	null	A	D	null
5	E	59	60	1	A	D	E
6	F	59	60	10	A	D	F