This content has been marked as final. Show 3 replies
I'm trying to fill the company names in the lower hierarchies from where the first criteria LineNum = 1.
So if LineNum = 1 on Company D then the NewCompanyName should be D,
If LineNum = 0 on Company H then the NewCompanyName should be a company for each existing company on every level meaning rows for A,B,D,H
Basically I want to check if LineNume = 1 then grab the the CompanyName for that row and use it, otherwise use the CompanyName as is.
Sorry about the bad explanation
The example is just a test I started with.