Combine multiple columns into one cell with header information in Excel
#Combine #multiple #columns into one cell with #header #information in Excel
1. Uses the IF function to test whether each information cell has data (I'm assuming that you will always have the name).
2. If the cell does, concatenate the character representation of the ASCII code for a carriage return (CHAR(10)) and the data for that cell.
3. Be sure to turn on wrapping for the formula cell, or the text that is displayed won't show the line breaks.
How to Create Quiz Question Paper on Google Forms
• How to Create Quiz Question Paper on Googl...
Bakery Products Order using "Google Forms"
• Bakery Products Order using "Google Forms"