I have a sheet of data in the form:Date           Val2015-08-05     102015-08-09     132015-08-14     4I am trying to display this data in other cell such that it looks like this:Date           Val2015-08        102015-08        132015-08         4I do not want to use a text() function that transforms yyyy-mm-dd to 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?Here is a sample spreadsheet for reference: https://docs.google.com/spreadsheets/d/1lG-iKRqoZ3BmBE58Uiy6C79hlDqSoCVxD1QVX-05Eyg/edit?usp=sharing
How to display dynamic range of data from another sheet, but while transforming one column
google spreadsheets