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 · Accepted solution]

@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.

[RNSEG]

Hi Griffinwelsh - this is helpful. Thank you. It will always be in that order. Thanks again for the solution!

[griffinwelsh]

Happy to help. Please mark this topic solved if you are satisfied with my solution.