Column Data Indenting

[SR]

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

[KaneG · Accepted solution]

Add a space in between merging... So the formula for Merged Column would be:

TrimRight([Lvl1] + ' ' + [2]  + ' ' + [3])