Forum Discussion
Solved
Splitting a table taking one portion and putting it under the other via LET - file format changed
I am hoping someone can help. I am running out of time and well out of skill. The attached spreadsheet is a subset of a much larger one. Essentially, the LET statement is very cool (DJClement) and...
PeterBartholomew1 - thanks for taking time to look at. I am good - finally - so many people happy now - but me more than any of them. I need to go back to my solution architect role.....
You appear to be sorted but, just for the record, I appeared to be making some progress by searching the header row for English and French data fields.
= LET(
enColIdx, XMATCH(desiredHdr, header),
frenchIdx, XMATCH(desiredHdr & " FR", header),
frColIdx, IFERROR(frenchIdx, enColIdx),
rowIdx, SEQUENCE(ROWS(body)),
stacked, VSTACK(INDEX(body,rowIdx,enColIdx), INDEX(body,rowIdx,frColIdx)),
FILTER(stacked, TAKE(stacked,,1)<>"")
)
PeterBartholomew1 - thanks for taking time to look at. I am good - finally - so many people happy now - but me more than any of them. I need to go back to my solution architect role.....