SSIS data load - How do I load data from csv file which has first few rows that have to be transposed to columns and load remaining data as is

Question

I need to load data from a csv file to SQL via SSIS. The data in the csv file is as follows:

I need the data to be loaded into SQL in the below format. how can I achieve this through SSIS?