Illustrate the use of Excel's 'TEXTJOIN' function in data consolidation.
Instruction: Provide a scenario where 'TEXTJOIN' would be used to merge data from multiple cells or ranges.
Context: This question evaluates the candidate's knowledge of Excel's text manipulation functions, specifically 'TEXTJOIN', for efficient data consolidation and manipulation.
Updated
Official answer available
Read the opening below, then unlock the full answer and practical guidance.
The 'TEXTJOIN' function is a relatively recent addition to Excel's arsenal, providing a straightforward yet powerful way of combining text...