I have a question for advanced Excel users that none of the AI applications were able to h

I am trying to create a formula or something with VBA to help me sort five columns of data.

I?ll briefly explain ? I use video games to learn languages, and I?m trying to create a multi-subtitle system for Baldur?s Gate 3. The text is organized via Content UIDs (for all languages). Unfortunately, in each language file the UIDs are not ordered the same, so I am unable to sort and align them to combine them into one cell.

Here is an example of the cells and the UIDs:


<content contentuid="h000006d4gcefbg4092gbb39gfeb27a3bb0a7" version="1">Sorry, darling, I haven't got time for underlings.</content>
<content contentuid="h000006d4gcefbg4092gbb39gfeb27a3bb0a7" version="1">抱歉，亲爱的，我可没时间搭理下属。</content>
<content contentuid="h000006d4gcefbg4092gbb39gfeb27a3bb0a7" version="1">Lo siento, cielo, no tengo tiempo para subordinados.</content>
<content contentuid="h000006d4gcefbg4092gbb39gfeb27a3bb0a7" version="1">Прости, моя радость, со слугами не разговариваю.</content>
<content contentuid="h000006d4gcefbg4092gbb39gfeb27a3bb0a7" version="1">D?sol?, tr?s cher, je n'ai pas de temps ? perdre avec les sous-fifres.</content>

And here is what I want it to look like :

<content contentuid="h000006d4gcefbg4092gbb39gfeb27a3bb0a7" version="1">Sorry, darling, I haven't got time for underlings. || RU: Извините, дорогая, у меня нет времени для подчиненных. || ES: Lo siento, cari?o, no tengo tiempo para los subordinados. || FR: D?sol?, ch?rie, je n'ai pas le temps pour les subalternes. || ZH: 抱歉，亲爱的，我没有时间的下降时间。</content>

There are over 200,000 of these lines of dialogue. My question - is there any way to have the other four columns (B-E) align in order using Column A as a reference using the unique UIDs?

Hopefully someone knows how to do this, because AI is not up to the task yet!

Crossposted here : https://www.mrexcel.com/board/thread...-with.1243061/

Without a language key this is kind of not doable, also cross posted on MrExcel

1. Please upload a SMALL sample Excel file, showing what you have AND what you want.

2. You have cross-posted this in at least ONE other place. That's OK. But don't keep it a secret. Aprat from Mr Excel - have you posted it ANYWHERE else?

3. Your title is awful - it tells us NOTHING about your request. I will change it, once I understand your request... or (preferably) YOU change it to soemthing meaningful.

First, as Excel is very not an AI application …
As the issue is not AI applications but the user …
Under Excel, if no logic to apply : no solution …
Wild cross posting = no help …

@iccy123

Please ignore this comment:

Wild cross posting = no help …

The Moderator (Glenn) has already addressed the cross-posting issue, but you MUST answer his questions. It is not forum policy to deny help to anyone who has cross posted, but they do have to tell us where they have done so.