Forum Discussion
Excel formula help
Hi all - I have a list of 180 offices across the Uk and I have a list of 85 tasks that need to be assigned to to each office for example Office Task Manchester Task ...
=LET(location,A2:A181,task,B2:B86,HSTACK(TOCOL(IFNA(EXPAND(location,,COUNTA(task)),location)),TOCOL(IFNA(EXPAND(task,,COUNTA(location)),task),,TRUE)))
If you have Office 365 you can apply this formula.