Hierarchy / Grouping

Raj008

Hi All,

My data set is,

Plant	Unit	Section	Asset
ABC	Unit 1	Wet Plant	Dryer
ABC	Unit 2	Sand Grind	Ultra Fine
ABC	Unit 3	RN1234	Mill
ABC	Unit 1	Wet Plant	Pulveizer
ABC	Unit 2	Sand Grind	Drive
ABC	Unit 3	RN1234	Robot
ABC	Unit 1	Wet Plant	Bagger
ABC	Unit 2	Sand Grind	Pump
ABC	Unit 3	RN1234	Fan

I need the following output

Plant	Unit	Section	Asset
ABC	Unit 1	Wet Plant	Dryer
			Pulveizer
			Bagger
	Unit 2	Sand Grind	Ultra Fine
			Drive
			Pump
	Unit 3	RN1234	Mill
			Robot
			Fan

How to group it / give it as a hierarchy?

Thanks,

Raj...

mst3k

it's not pretty but one way would be to make sure your data is sorted and then use multi-row tools to check the value in the row above, and set blank if it's equal to it.

PseudoTable.yxmd