HI All,
I have a main column which is merged from 3 different columns.
Level 1
Lvl1 | 2 | 3 | Merged Column |
ABC | ABC | ||
XYZ | XYZ | ||
def | def |
what i am trying to do is indent on the merged column when lv1 is null.
output desired
ABC
XYZ
def
How do i achieve this?
thanks
SR
Solved! Go to Solution.
Add a space in between merging... So the formula for Merged Column would be:
TrimRight([Lvl1] + ' ' + [2] + ' ' + [3])