How can I move children from primary task column into new columns in the parent row

Rachel Kaberon

Initially the team asked for all of our project entries to be in a single column, and common subgroups be indented. Later, management realized they wanted to be able to see the subgroups as columns. I've successfully matched the subgroup row name and move it into the new column but been unable to move the contents into the project's parent row. I've tried a series of helper columns

=IF(AND((MATCH([Level P]@row, ANCESTORS(Project@row), 0)), (MATCH("Architect", Project@row, 0))), VALUE([Joined CDetails]@row), " N/A")

but missing something , any suggestions?

James Keuning

Maybe someone else will understand more clearly, but I do not understand... if you use a column with indentation, you can have an unlimited number of rows. But you want to pivot that out to columns? How do you know how many columns you need? Is every project the same in terms of the rows?

Can you manually mock up current state and desired state and screen shot both? Then we can figure out if some formulas will get you there.