I have one dataset with 3 fields.

FIELD_NAME column can have a dynamic number of standard values. It might have 10, but tomorrow it might have 11 or even more.
I would like to PIVOT that table (one column for each FIELD_NAME) and group everything by ID.
I managed to do this dynamically by using this script, but I do not know how to save this as a view/or table to use the output (table or view) easily in other queries.
I managed to create a view but it automatically hardcodes the fields. It is not something dynamic. Is it possible to trigger & run a procedure multiple times per day?