Split a table into multiple tables based on column value in excel

=FILTER($A$2:$C$168,$D$2:$D$168=G1)

[@oakerthwin8042]

Woahhhh. You used a lot of shortcuts that I have never seen before. So much efficiency!!! Thank you so much for this video.

[@ТувеЯнссон-о3у]

Fantastic! Thank you very much.

[@aliab2201]

Wow! You showed techniques I've never seen before. The sample is using the format painter, Man I have been using it all wrong.😅

[@artofsalsa5268]

Thanks for the informative video Just a side note: To fill a row of unique years separated by n spaces:
mySpacedYears : = LAMBDA(range,n,TEXTSPLIT(TEXTJOIN(",",TRUE,UNIQUE(range)&REPT(",",n)),","))
So n would be 3 - if 3 spaces are required between 3 years.
And range is D2:D168 in the video.
Please let me know if there's a simpler way than my formula.