If I need to create a table that will store data once a week and keep the last 12 weeks, how would I do that?

Once 12 weeks are collected, how do you shift data up in the table?