Today's formula =text(value, "yyyy-mm")

today we learned to format the date to see year and months only.  It was really simple. much easier than doing the concatenate formula
 to bring it out.

The transpose function is a gem.   I was stupidly doing it line by line without knowing that I would do it in batch.