its an example I have a file in Excel that contains 20 columns with textual content and these contents are regularly either edited or added to each column. I want to create a new column that contains the content of all the other columns. For example, if the previous 20 columns have 5 text cells each, this new column contains 100 text cells based on the previous columns and is waiting to be added or edited in the previous columns.
1 Answers
It's hard to understand exactly what you're doing, but if you put this function in cell U1 it will spill down all values in the prior 20 columns.
=FILTERXML("<r><c>"&TEXTJOIN("</c><c>",TRUE,A:T)&"</c></r>","//c")
This won't work on mac or web instances of excel.
If you have the latest Excel formulas that recently came out in 2022, then you could also use this formula which is available for Excel on Web.
=TEXTSPLIT(TEXTJOIN("????",TRUE,A:T),,"????")
Related