How to organize a data array using a single formula so that the output is a table like the sample to the right of the array (done manually)? Criteria:
File link: https://docs.google.com/spreadsheets/d/1cjbvCyQaW2XL9dXb9RQSVOdJBG8alrqbrFc4r-XueLQ/edit#gid=0
You may try:
=let(Λ,map(A:A,lambda(Σ,if(iserror(Σ),substitute(formulatext(Σ),"=+",),Σ))),
tocol(choosecols(wraprows(Λ,14),14),3))