Forum Discussion
Solved
how turn table data into one row per record
I have a table that looks like this and I'm trying to turn the data with the same "kind" into one row like the table below I have been searching for ways to do it but couldn't find any. I a...
=LET(rng,B2:Q11,data1,TAKE(rng,,5),data2,TAKE(rng,,-11),z, BYROW(data1,LAMBDA(x,CONCAT(x))),HSTACK(UNIQUE(data1), IFNA(DROP(REDUCE("",UNIQUE(z),LAMBDA(u,v,VSTACK(u,TOROW(FILTER(data2,z=v))))),1),"")))In Excel for the web or Office 365 you can apply this formula.
=LET(rng,B2:Q11,data1,TAKE(rng,,5),data2,TAKE(rng,,-11),z,
BYROW(data1,LAMBDA(x,CONCAT(x))),HSTACK(UNIQUE(data1),
IFNA(DROP(REDUCE("",UNIQUE(z),LAMBDA(u,v,VSTACK(u,TOROW(FILTER(data2,z=v))))),1),"")))In Excel for the web or Office 365 you can apply this formula.
thank you so much!
