Need help in data customized filtration

[anonymous008_G]

Hi Folks --- I have a very large amount of unstructured data in the table as sample below. From the sample data I want to only filter out specific rows in output which is ACCOUNT1, INDEX1 and 5 record. How would I do that? Please help.

Column1	One Year as of 12/31/23	One Year as of 12/31/22	One Year as of 12/31/21	One Year as of 12/31/20
ACCOUNT1	1.2	6.3	2.2	1.32
INDEX1	5.36	23.1	83.6	14.6
High	9.52	39.9	165	27.88
Low	13.68	56.7	246.4	41.16
Risk	17.84	73.5	327.8	54.44
Null	22	90.3	409.2	67.72
5	One Year as of 12/31/23	Two Year as of 12/31/23	Three Year as of 12/31/23	Four Year as of 12/31/23
ACCOUNT1		123.9	572	94.28
INDEX1	34.48	140.7	653.4	107.56

[cjaneczko]

Create an index with the formula tool and then filter on the index.

if [Column1] in ('ACCOUNT1','INDEX1','5') then 'X' else '' endif