How to change arrays into rows
Solution 1:
Consider below approach
select t.* except(entered_date, status),
entered_date, status
from your_table t,
t.entered_date as entered_date with offset
join t.status as status with offset
using(offset)
if applied to sample data in your question - output is
