Trying to find a sensible improvement to below formula, such that separators " | " would only be included for the cells that are in fact populated. To avoid outcomes like this:
But instead to get automatically result like this:
Here's the formula I'm running:
=CONCATENATE("ABC EFG - " &K6&"|"&L6&"|"&M6&"|"&N6&"|"&O6&"|"&P6&"|"&Q6&"|"&R6&"|"&S6&"|"&L7&"|"&M7&"|"&N7&"|"&O7&"|"&P7&"|"&Q7&"|"&R7&"|"&S7&"\")
ABC EFG - KF12345|KF54321|||||||||||||||\ |
But instead to get automatically result like this:
ABC EFG - KF12345|KF54321 |
Here's the formula I'm running:
=CONCATENATE("ABC EFG - " &K6&"|"&L6&"|"&M6&"|"&N6&"|"&O6&"|"&P6&"|"&Q6&"|"&R6&"|"&S6&"|"&L7&"|"&M7&"|"&N7&"|"&O7&"|"&P7&"|"&Q7&"|"&R7&"|"&S7&"\")