Trying to fill the Nulls

RNSEG

Hi I am attempting to fill the nulls in these table below. The left is the input and the right is the desired output. I would prefer not to filter out each timeframe section into 3 and hopefully try to figure out a way that can fill the nulls as so. This solution would hopefully work for similar tables but with different amount of rows. Does anybody have a good suggestion here? Thank you in advance. 

Period From:	1/1/2024		Period From:	1/1/2024
Period To:	3/31/2024		Period To:	3/31/2024
Entity:	Private Equitea Fund		Entity:	Private Equitea Fund
[Null]	Name 1		QTD	Name 1
[Null]	Name 2		QTD	Name 2
[Null]	Name 3		QTD	Name 3
[Null]	Name 4		QTD	Name 4
[Null]	Name 5		QTD	Name 5
[Null]	Name 6		QTD	Name 6
[Null]	Name 7		QTD	Name 7
[Null]	Name 8		QTD	Name 8
[Null]	Name 9		QTD	Name 9
[Null]	Name 10		QTD	Name 10
[Null]	Name 11		QTD	Name 11
[Null]	Name 12		QTD	Name 12
[Null]	Name 13		QTD	Name 13
[Null]	Name 14		QTD	Name 14
[Null]	Name 15		QTD	Name 15
[Null]	Name 16		QTD	Name 16
Period From:	1/1/2024		Period From:	1/1/2024
Period To:	3/31/2024		Period To:	3/31/2024
[Null]	Partner Name		YTD	Partner Name
[Null]	Name 1		YTD	Name 1
[Null]	Name 2		YTD	Name 2
[Null]	Name 3		YTD	Name 3
[Null]	Name 4		YTD	Name 4
[Null]	Name 5		YTD	Name 5
[Null]	Name 6		YTD	Name 6
[Null]	Name 7		YTD	Name 7
[Null]	Name 8		YTD	Name 8
[Null]	Name 9		YTD	Name 9
[Null]	Name 10		YTD	Name 10
[Null]	Name 11		YTD	Name 11
[Null]	Name 12		YTD	Name 12
[Null]	Name 13		YTD	Name 13
[Null]	Name 14		YTD	Name 14
[Null]	Name 15		YTD	Name 15
[Null]	Name 16		YTD	Name 16
Period From:	7/1/2018		Period From:	7/1/2018
Period To:	3/31/2024		Period To:	3/31/2024
[Null]	Partner Name		ITD	Partner Name
[Null]	Name 1		ITD	Name 1
[Null]	Name 2		ITD	Name 2
[Null]	Name 3		ITD	Name 3
[Null]	Name 4		ITD	Name 4
[Null]	Name 5		ITD	Name 5
[Null]	Name 6		ITD	Name 6
[Null]	Name 7		ITD	Name 7
[Null]	Name 8		ITD	Name 8
[Null]	Name 9		ITD	Name 9
[Null]	Name 10		ITD	Name 10
[Null]	Name 11		ITD	Name 11
[Null]	Name 12		ITD	Name 12
[Null]	Name 13		ITD	Name 13
[Null]	Name 14		ITD	Name 14
[Null]	Name 15		ITD	Name 15
[Null]	Name 16		ITD	Name 16

griffinwelsh

@RNSEG if your data is always in the same order QTD,YTD,ITD then this attached solution will work. Otherwise please explain how you arrive at determining which section gets each label.

Sample sol.yxmd