I have a spreadsheet with row 1 set to role_id
Column a is screen_id
the cells have a code where they meet. see below.

A     B     C
     123   122  
Scr1  A     D   
Scr2  S     A   

I need to create rows in a database that look like below

Role   Screen    Display     Edit     Add
123     Scr1       Y          Y        Y
123     Scr2       N          N        N
122     Scr1       Y          N        N
122     Scr2       Y          Y        Y

Is there a SSIS or vba or even .net code that can do this straightforward?

Many thanks for any help!!

btw, I have to use the code and translate it to set the flags correctly. What I dont understand is how to match the row and column cells and create multiple records from each row/column.