Yes it is, thanks.
If you have Excel through Office 365, try the A4 formula copied across. In fact, if only 3 cells, that formula could be =A1&A2&A3
If an older version, try the A5 formula (assuming the non-empty cells contain text, like your samples, not numbers)
Get value
| A | B |
1 | ABC | |
2 | | ZYZ |
3 | | |
4 | ABC | ZYZ |
5 | ABC | ZYZ |
<colgroup><col style="font-weight:bold; width:30px; "><col style="width:76px;"><col style="width:55px;"></colgroup><tbody>
</tbody>
Spreadsheet Formulas |
Cell | Formula | A4 | =CONCAT(A1:A3) | A5 | =LOOKUP(REPT("Z",255),A1:A3) |
<tbody>
</tbody> |
<tbody>
</tbody>
Excel tables to the web >> Excel Jeanie HTML 4