Hi, I'm trying to create a table with 3 columns and 10 rows. I need to restrict the table so that each user can only see their own data. However, I also want to provide one column with pre-filled values that every user can see, as a guide to completion. 

Column 1 contains category labels. This is the column that I want every user to see pre-filled. (Ideally they should also be able to change these labels, but I'm willing to sacrifice this if necessary.)

Column 2 and 3 are supplied empty for completion by the user. This generates a personalised chart below the table. 

I also want admin to see and store all completed tables and charts. 

How can I achieve this? I can't find a way to make individual columns visible to everyone.

Thanks

Hi Aleksandar,

Thanks for your reply. I've attached here a screenshot of the Excel version of the table I'd like to replicate on my site. The Values column should be constant for all users. When a user first logs in, they should see the Values column already complete but the Priority column should be empty, for them to fill. The Priority column should allow only the 4 validated responses in a dropdown (and maximum 20 "top 20" responses, max. 10 "top 10" responses, and max. 3 "top 3" responses). 

Does this make more sense?

Thanks

Paul