putting row labels within a group

[xariet]

Hi All!

I need help with putting labels on the rows within a group. 

for example, I have the following data and, in my output, I need an additional column "Category" with the category name within each group (group is based on school ID). 

output

SchoolID	Date School Renamed	SchoolName	Category
1	1/05/2016	SantaClaus	original
1	1/07/2018	SaintNicholas	first
1	1/10/2018	KrisKringle	second
1	1/04/2019	DedMoroz	third
2	1/10/2017	Big	original
2	1/05/2018	Large	first
2	1/10/2018	Hefty	second
2	1/04/2019	Colossal	third
3	1/08/2017	Small	original
3	1/06/2018	Limited	first
3	1/09/2018	Poor	second
3	1/05/2019	Mini	third
3	1/11/2019	Micro	forth
4	1/04/2018	Sleepy	original
4	1/12/2019	Quiet	first
4	1/08/2020	Relaxed	second

thank you for any inputs

[TimN · Accepted solution]

Hi,

This could work.

Tim

[xariet]

@TimN thank you !

[binuacs · Accepted solution]

@xariet Updated your workflow