Rearrange CrossTabbed Data With Open-Ended Number Of Rows And Columns (Sheet1) Into DataBase Style (Sheet2)

Google Spreadsheet   Post  #2388

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Mar-05-2018

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

Hi,

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.

Location/Month	Jan	Feb	Mar
Site 1	$100		$150
Site 2		$100
Site 3		$100

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?

Location	Month	Values
Site 1	Jan	$100
Site 1	Feb
Site 1	Mar	$150
Site 2	Jan
Site 2	Feb	$100
Site 2	Mar
Site 3	April	$100
Site 3	May
Site 3	June	$150

Thanks in advance for you assistance with this.