Is there anyway I can consolidate Table 1 into Table 2, without first sorting by 'County' and then using 'ARRAYTOTEXT' multiple times? (preferably alphabetical order)
Any help would be highly appreciated!
Thank you.Excel Question.JPG
Is there anyway I can consolidate Table 1 into Table 2, without first sorting by 'County' and then using 'ARRAYTOTEXT' multiple times? (preferably alphabetical order)
Any help would be highly appreciated!
Thank you.Excel Question.JPG
Last edited by ellieholmes; 05-03-2022 at 09:41 AM.
Administrative Note:
Welcome to the forum.
ARRAYTOTEXT is not available in Excel 2006, so please check that your forum profile is up-to-date in this respect. If you aren't sure, in Excel go to File | Account and report what it says below the MS logo at the top of that page. If your version is for Mac, please also state this. Thanks.
PS I come from Long Eaton!
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
If you have 365 or 2021 you could use in E2and in F2 copied downFormula:Please Login or Register to view this content.Formula:Please Login or Register to view this content.
In E2:
=UNIQUE(A2:A10)
In F2 copied down:
=ARRAYTOTEXT(FILTER(B2:B10,A2:A10=E2),0)
Thanks so much Ali, Long Eaton is a lovely city
I have also amended my forum profile to the correct excel Version.
It's a town, not a city, and it's far from lovely!
Glad to have helped - thanks for the rep.
Glad to help & thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks