yogi_Concatenate FieldHeaders And Multiple Comma Separated Field Values Row By Row For An Open Ended Number Of Fields In Table

                                          Google Spreadsheet   Post  #1134
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Apr 17, 2013
user luscas cervera :(http://productforums.google.com/forum/?zx=m2hy26mxofcx#!mydiscussions/docs/2XouhjJMHTY)

the solution in this post addresses solution to a bit more more generalized problem than presented in my following blog post:

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

http://yogi--anand-consulting.blogspot.com/2013/04/yogiconcatenate-fieldheaders-and-field.html

--------------------------------------------------------------------------------------

so here we go

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

yogi_Compile List Of Children From A Table Of ID (Objects) And Parents

                                          Google Spreadsheet   Post  #1095
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Apr 3, 2013
user lucas cervera :(http://productforums.google.com/forum/?zx=saj65vfnlqxo#!category-topic/docs/spreadsheets/CrGHECidqnI)
hi,

I have a sheet were each row represents an object. Some objects have a parent object. I would like to do the following.

Column A is called "ID" and has a unique ID for each object.

Column B is called "PARENT" and lists the object's parents IDs (separated by commas). Objects can have multiple parents.

Column C is called "CHILDREN" and lists the IDs (separated by commas) of all objects that have that object as parent.

For example

ID           PARENT        CHILDREN

1                                       2,4

2                1                      4

3                                        5

4               1,2

5                 3

The number of objects will grow over time. Is it possible to do this by writing an ARRAYFORMULA in column C?

Thanks in advance,

Lucas

---------------------------------------------------------------------------------------------------------------

following is a solution to the problem
in Sheet1 I used the data as in user Lucas' original post, and
in yogi_Sheet1, I inserted more IDs to see how this solution will scale as more data is inserted ... so far so good