Creating Parent and Child hierarchy

[orangebloss]

The data I have is pulled from an API that I'm yet to find a suitable field for.

I'm trying to find a way to group the data into hierarchical tasklists.

The data is returned like this:

Project Name	Task List	Parent Task	Task
ABC	123	John Smith	Write 1
ABC	123	Write 1	Write 1.1
ABC	123	John Smith	Write 2

However, what I want to do is to be able to return the parent of the parent, so in this instance the parent of the parent of Write1.1 is John Smith (if that makes sense). In a pivot table it would look like this:

ABC
	123
		John Smith
			Write 1
				Write1.1
			Write 2

Alternatively allocating each of the hierarchical levels with a parent indicator (i.e. Parent1 , Parent2 etc) and returning one of those specific fields?

Parent 1	Parent 2	Parent3	Parent4	Parent5
ABC	123	John Smith	Write 1	Write 1.1

I appreciate this is probably not very well worded and potentially not very clear so any help is appreciated!

[steeefan · Accepted solution]

Hierarchy load might be what you need.

[orangebloss]

Brilliant thanks! Now to work out how to count them all!