Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
parent/child relationship between rows?
3,407 views
Skip to first unread message
Doug
Jan 27, 2010, 12:23:01 PM1/27/10
to
I have a list of about a thousand rows. I want to divide these rows by
inserting new rows as 'headers' for certain groups of rows. is there a way
to 'attach' the rows below the 'header' row? When i do a sort over the
entire spreadsheet, I want the 'child' rows to maintain a relationship to the
'parent/header' row. TIA
inserting new rows as 'headers' for certain groups of rows. is there a way
to 'attach' the rows below the 'header' row? When i do a sort over the
entire spreadsheet, I want the 'child' rows to maintain a relationship to the
'parent/header' row. TIA
Eva
Jan 27, 2010, 12:41:02 PM1/27/10
to
Hi
I would create a new column called for example "Group" and fill in all rows
(don't leave blanks there) then clik Data/Group and outline/group
I would create a new column called for example "Group" and fill in all rows
(don't leave blanks there) then clik Data/Group and outline/group
Click yes if helped
--
Greatly appreciated
Eva
Doug
Jan 27, 2010, 2:01:01 PM1/27/10
to
Eva, I can see how this might help. But it leaves me to sort by this new
Group in order to keep the relationship between the header (parent) and
subsequent rows (children). We may want to sort the spreadsheet, but only by
the headers while keeping the children 'attached' to the parent.
Group in order to keep the relationship between the header (parent) and
subsequent rows (children). We may want to sort the spreadsheet, but only by
the headers while keeping the children 'attached' to the parent.
Eva
Jan 27, 2010, 2:59:02 PM1/27/10
to
Hi
I still think that it should work, even you don't have to group it (I don't
like this future and I don't use it actually), but creating a colum called
"group" or "header" should really help. example
group data
A 1
A 2
B 1
B 3
B 5
etc
so when you sort by the colum A (group) all data are "attached" to the
group, so I think it should solve the problem you have
I still think that it should work, even you don't have to group it (I don't
like this future and I don't use it actually), but creating a colum called
"group" or "header" should really help. example
group data
A 1
A 2
B 1
B 3
B 5
etc
so when you sort by the colum A (group) all data are "attached" to the
group, so I think it should solve the problem you have
0 new messages