Hello. I have large spreadsheets that have thousands of rows and in some cases almost 100 columns. At the intersections of some rows and columns are data. I am looking to flatten that big matrix out to make an individual row for each row & col intersection that contains data:
Take
model 1 model 2 model 3 model 4 model 5
name 1 2 7 4
name 2 3 5 3
name 3 2 6 9
name 4 1 5 7
name 5 6 8 12
and make
name 1 model 2 2
name 1 model 4 7
name 1 model 5 4
name 2 model 1 3
name 2 model 3 5
name 2 model 5 3
name 3 model 2 2
name 3 model 3 6
name 3 model 4 9
name 4 model 1 1
name 4 model 3 5
name 4 model 5 7
name 5 model 3 6
name 5 model 4 8
name 5 model 5 12
Take
model 1 model 2 model 3 model 4 model 5
name 1 2 7 4
name 2 3 5 3
name 3 2 6 9
name 4 1 5 7
name 5 6 8 12
and make
name 1 model 2 2
name 1 model 4 7
name 1 model 5 4
name 2 model 1 3
name 2 model 3 5
name 2 model 5 3
name 3 model 2 2
name 3 model 3 6
name 3 model 4 9
name 4 model 1 1
name 4 model 3 5
name 4 model 5 7
name 5 model 3 6
name 5 model 4 8
name 5 model 5 12