Rainbow_P
New Member
- Joined
- May 6, 2022
- Messages
- 21
- Office Version
- 365
- Platform
- Windows
Good day!
Raw data as in columns A, B, C.
A way is needed to join the column header and texts in rows, when the cells are not empty.
I am currently using TEXTJOIN("&",TRUE,"Name: "&A2,"Gender: "&B2,"Area: "&C2) in D2, but it includes the header when the cells are empty.
How can I achieve the results sampled in column E?
Thank you.
Raw data as in columns A, B, C.
A way is needed to join the column header and texts in rows, when the cells are not empty.
I am currently using TEXTJOIN("&",TRUE,"Name: "&A2,"Gender: "&B2,"Area: "&C2) in D2, but it includes the header when the cells are empty.
How can I achieve the results sampled in column E?
Thank you.