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,