replace null in columns before unpivoting

Question

Hey guys,&nbsp;Can I fill the nulls across to the right and go one row down and get the month as well?see image below&nbsp;Expected results&nbsp;

johnag · Accepted Answer

The solution was to transpose the whole tabel I was unpivoting.&nbsp;thanks&nbsp;

Forum Discussion