Hi all,
good morning! I'm in need of help to figure out how to concatenate columns by a dash with 5 character each column but if the column is empty the formula must ignore move on to the next column.
Columns a | b | c | d | e | f | g | h |
this is how it should be concatenated and please note the length value inside the column should 5 so i need automatic leading zero if my value each col is less than 5:
Column grouping: A-b | c-d | e-f | g-h
a | b | c | d | e | f | g | h |
blk1 | blk2 | blk3 | | blk5 | blk6 | blk7 | |
output should be: 0blk1-0blk2 0blk3 0blk5-0blk6 0blk7
please help!
Bookmarks