Join/Collect Multiple Columns to One Cell WITH Column Name
I'm trying to combine data from multiple columns across a row into one cell in that row that I can zap to another program. I'd like for the information from each column to be preceded by the column name. (Example "Column Name: Column 1 Data, Column 2 Name: Column 2 Name: Column 2 Data, etc.)
I've figured out how to collect the data from each column and include a line break between each, but I'm stuck at how to insert the column names that correspond to the data. I have the Column Names in a helper row, row 1.
My working formula:
=JOIN((COLLECT(Program@row:[Time tracker ISBN]@row, Program@row:[Time tracker ISBN]@row, @cell <> "")), CHAR(10))
Is there a way to insert the Column Name (row 1) into the formula?
Best Answer
-
You would have to write it out more long form.
=IF([FIrst Column]@row <> "", "FIrst Column: " + [First Column]@row + CHAR(10)) + IF([Second Column]@row <> "", "Second Column: " + [Second Column]@row + CHAR(10)) + IF([Third Column]@row <> "", "Third Column: " + [Third Column]@row + CHAR(10)) + ..................................
Answers
-
You would have to write it out more long form.
=IF([FIrst Column]@row <> "", "FIrst Column: " + [First Column]@row + CHAR(10)) + IF([Second Column]@row <> "", "Second Column: " + [Second Column]@row + CHAR(10)) + IF([Third Column]@row <> "", "Third Column: " + [Third Column]@row + CHAR(10)) + ..................................
-
@Paul Newcome Yes! That did it. Thank you!
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!