Based on your screenshot, the following Excel macro should do the job. Note the comment at the start of the macro as you will need to get some additional code from the link.
Option Explicit
'Graham Mayor - https://www.gmayor.com - Last updated - 23 Feb 2020
Sub CreateOutlookTasks()
Dim xlSheet As Worksheet
Dim LastRow As Long, LastCol As Long
Dim lngCol As Long, lngRow As Long
Dim strSubject As String
Dim strDate As String
Dim dDate As Date
Set xlSheet = ActiveSheet
With xlSheet
LastRow = .Cells(.Rows.Count, "A").End(xlUp).Row
LastCol = .Cells(4, .Columns.Count).End(xlToLeft).Column
For lngRow = 9 To LastRow
For lngCol = 3 To LastCol
If Not .Cells(lngRow, lngCol) = "" Then
strSubject = .Cells(lngRow, lngCol)
strDate = .Cells(lngRow, 1) & Chr(32) & CDate(.Cells(4, lngCol))
dDate = CDate(strDate)
AddTask strSubject, dDate
End If
Next lngCol
Next lngRow
End With
MsgBox "Task list created"
lbl_Exit:
Set xlSheet = Nothing
Exit Sub
End Sub
Private Sub AddTask(strSubject As String, dDate As Date)
'Graham Mayor - https://www.gmayor.com - Last updated - 23 Feb 2020
'Requires the code by Ben Clothier - http://www.rondebruin.nl/win/s1/outlook/openclose.htm
'to either retrieve an open instance of Outlook or open Outlook if it is closed.
Dim olApp As Object
Dim olTask As Object
On Error GoTo err_Handler:
Set olApp = OutlookApp()
Set olTask = olApp.CreateItem(3)
With olTask
.Subject = strSubject
.StartDate = dDate
.DueDate = dDate
.Importance = 2
.ReminderSet = True
.ReminderTime = dDate
.Close 0
End With
lbl_Exit:
Set olApp = Nothing
Set olTask = Nothing
Exit Sub
err_Handler:
Beep
MsgBox "User Cancelled", vbCritical, "Cancelled"
Err.Clear
GoTo lbl_Exit
End Sub