I'd like to split a csv column containing a dictionary-like structure/values into component columns. For example input/output data, see

CodePudding user response：

use in B3:

=INDEX(BYROW(A3:A5, LAMBDA(x, IFNA(HLOOKUP(B2:E2, 
 TRANSPOSE(SPLIT(TRIM(FLATTEN(SPLIT(REGEXREPLACE(x, "[\}\{"",]", ), 
 CHAR(10)))), ":")), 2, 0)))))