hello all,

 

 

i got an excel file with two columns, one with reference letter and one with a value,

 

i want to turn the values into headers within a SQL tables, each sql table being one reference number

 

what would be the best way going about it?

 

 

i have been messing around with listbuilder then expose the values which does give me one row per reference number, also each reference number has a different amount of values, so exposing them leaves a lot of missing values and i am still lost on how to turn them into header, maybe a custom transformer with a loop could help?

 

 

any help would be great,