Forum Discussion
Solved
How to make a list from an excel spreadsheet with many columns
Hi, I have an excel spreadsheet with results from an order form. I'm trying to get a formula to format each line into a list showing exactly what each person purchased. I was using the CONCATENATE ...
You need a different kind of formula in Excel 2016. TEXTJOIN is not available there. Try this:
=A2&IF(B2="","",CHAR(10)&"- "&B2&" "&B$1)&IF(C2="","",CHAR(10)&"- "&C2&" "&C$1)&IF(D2="","",CHAR(10)&"- "&D2&" "&D$1)&IF(E2="","",CHAR(10)&"- "&E2&" "&E$1)&IF(F2="","",CHAR(10)&"- "&F2&" "&F$1)&IF(G2="","",CHAR(10)&"- "&G2&" "&G$1)
Yes, i think its because i'm using Excel 2016. How would i use it as an array formula? Thanks!
You need a different kind of formula in Excel 2016. TEXTJOIN is not available there. Try this:
=A2&IF(B2="","",CHAR(10)&"- "&B2&" "&B$1)&IF(C2="","",CHAR(10)&"- "&C2&" "&C$1)&IF(D2="","",CHAR(10)&"- "&D2&" "&D$1)&IF(E2="","",CHAR(10)&"- "&E2&" "&E$1)&IF(F2="","",CHAR(10)&"- "&F2&" "&F$1)&IF(G2="","",CHAR(10)&"- "&G2&" "&G$1)
- Thanks very much, that works great!! Really appreciate your help! 🙂
