With almost universal availability of Internet and the availability of reliable on-line productivity tools, such as Google Docs, individuals as well as companies are switching over to Cloud Computing. In this blog I will post items of interest to my colleagues/patrons/clients.
Monday, March 5, 2018
Rearrange CrossTabbed Data With Open-Ended Number Of Rows And Columns (Sheet1) Into DataBase Style (Sheet2)
question by: Pedro Franco https://productforums.google.com/forum/?utm_medium=email&utm_source=best_answer_notification_button#!topic/docs/V7YvYbV1-fc;context-place=forum/docs Transforming Data from a Table to a Database structure using Google Sheet
Apologies if this has already been addressed in these forums. I currently have a cost document that has multiple locations and monthly costs in the below layout.
As we are looking to plug in the this data into Google Data Studio I need to transform the data into a structure that will allow it to be better used in Google Data studio as below. Does anyone know of any code or app that would allow me to achieve this?