VSTACK tables with different number of columns

Question

Hi,&nbsp;I have 2 tables with different number of columns and that cause the text string to cut, because columns with errors is added to that table in VSTACK. I Can use IFERROR and hide the errors. But it still cut my text.&nbsp;&nbsp;Is it possible to wite the formula so it does not cut the text?&nbsp;&nbsp;See attached document for example.&nbsp;Best Regards&nbsp;Geir

hansvogelaar · Answer

I don't think so - the cells aren't really empty.
You'll have to autofit the columns, or turn on Wrap Text.

riny_van_eekelen · Answer

Isn't this doing what you need?=IFERROR(VSTACK(B14:E14, BYROW(t_evtxt,LAMBDA(mr,TEXTJOIN(" ",TRUE,mr)))),"")&nbsp;

hogstad_raadgivning · Answer

I used TextJoin, to solve it. The problem then, is that is also Textjoin the second table...&nbsp;

Forum Discussion

VSTACK tables with different number of columns

3 Replies

Resources