I was unable to find any formatting tools to align the text but I have provided a link to the sheet I am using. Source: Team Parent Team (ACT) ACT (AU) AU (NSW) NSW (AU) AU (NSW1) NSW1 One (AU) AU (QLD) QLD (AU) AU (VIC) VIC (AU) AU (Hybrid) HYBRID (NSW) NSW (Sydney) Sydney (NSW) NSW (AU) AU (P) P (Inactive) Inactive (Q) Q (Inactive1) Inactive1 (Q) Q (1000) ABC (Sydney) Sydney (Brighton) Brighton (VIC) VIC (Hybrid) HYBRID (VIC) VIC (Melbourne) Melbourne (VIC) VIC eg (but format as per linked file) (P) P => (AU) AU => (NSW) NSW => (Sydney) Sydney => (1000) ABC It needs to find levels based on teams in parent teams which are in parent teams which are in parent teams etc etc