Autofill column based on data grouping

[Blessing_Alabi]

Hii everyone,

I'm working on a dataset with grouped data on excel. I want to transfer the grouping to Tableau but do not want to do it manually as it will take a lot of time. Is it possible to populate a new column with data based on the groupings.