Get the value from a column

I have a column named “sales reps” in my table. The column has multiple names considering “x,y,z,a,b,c”.
I want all these names on my report. What formula should I use?
Similar to below google sheet.

Hi @Deeksha_Shanbhag,
If you have some external files that you want to import into eazyBI, you may want to check this documentation about Data mapping that explains how to import data into eazyBI and create a custom cube.

Also, you can check my presentation about this topic here: All Paws on Deck: Discover Data Mapping

Gerda //