When you apply Row owners to a table, sometimes the data will disappear and you simply need to refresh your browser for it to reappear. Data doesn’t go missing. It’s just a quirkiness in how the builder will display all data, even if you are not the row owner, but in reality, unowned rows would not be downloaded to a usercs device.
What you want is totally possible. If it’s a user profile table and you have user profiles configured (pointing to sheet 1), then normally you can just open the user profile from the app or page and you can add entry components directly on that screen, or you can enable an edit screen for them to edit their personal data.
If you have a separate profile tab and an all user tab, then you can point the profile tab to sheet 1 and the all user tab to sheet 2.
Sheet 1 would have row owners applied. Sheet 2 would not.
It should be a pretty basic setup. If you are stuck somewhere, it might help to see some screenshots of your configuration and how you have your data and screens set up.