Google Sheets Filter and Replace Array-CodePudding

I have a sheet that contains a list of tables from a SQL Server and for each table, their respective column data types. I am looking for a way to output a standard value for each data type in the order it is received.

Hopefully this isn't too confusing, essentially instead of outputting results from filter, I want to run them through one more formula to replace the filtered value with a new value. I just can't seem to figure out a short method and keeping it an array.

CodePudding user response：

try:

=IFERROR(BYROW(FILTER(H2:H, H2:H<>""), LAMBDA(x, JOIN(", ", 
 INDEX(IFERROR(VLOOKUP(FILTER(G:G, C:C=x, F:F="NO"), 
 {"nvarchar","""abc""" ; "int",99}, 2, ), 
 FILTER(G:G, C:C=x, F:F="NO")))))))