Monday, April 15, 2013

yogi_Concatenate FieldHeaders And Field Values Row By Row For All Fields In Table


                                          Google Spreadsheet   Post  #1129
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI   
updated Apr-18-2016 to work with Google New Sheets
  www.energyefficientbuild.com.    Apr 15, 2013
user lucas cervera  :(http://productforums.google.com/forum/?zx=kaquw4uxiqns#!category-topic/docs/spreadsheets/2XouhjJMHTY)
arrayformula that concatenates the column headers and cell values

Hi,

I am trying to create an arrayformula that concatenates the column headers and cell values for a table with 3 fields.

field1 | field2 | field3 | fields
f1v1   |  f2v1 |  f3v1  | field1:f1v1,field2:f2v1,field3:f3v1
f1v2   |  f2v2 |  f3v2  | field1:f1v2,field2:f2v2,field3:f3v2
f1v3   |  f2v3 |  f3v3  | field1:f1v3,field2:f2v3,field3:f3v3

Any idea if this can be acomplished and how?

Thanks in advance,
Lucas
-----------------------------------------------------------------------------------------------------------------
following is a solution to the problem