I have a sheet of data in the form:
Date Val 2015-08-05 10 2015-08-09 13 2015-08-14 4
I am trying to display this data in other cell such that it looks like this:
Date Val 2015-08 10 2015-08 13 2015-08 4
I do not want to use a text() function that transforms
yyyy-mm and then drag that down column A. I want all of the data to be dynamically populated such that adding new columns to the source sheet causes the other sheet to update automatically.
How can I do this?