Sophie Martin 

In addition to the question from Jesús (which is correct) you said:

Sophie Martin said:

source column 3, target column 5

Yet you seem to have multilingual rows?  I created your test file and used it successfully in Studio like this:

Your test data:

service_location_id;language_id;name
-1;1;Inconnu
-1;2;EN_Inconnu
-1;3;NL_Inconnu
-1;4;DE_Inconnu

Studio:

Target file:

service_location_id;language_id;name
-1;1;Inconnu;;test1
-1;2;EN_Inconnu;;test2
-1;3;NL_Inconnu;;test3
-1;4;DE_Inconnu;;test4

Is this the output you want?

well, this is another problem I have to solve. I have no idea how to proceed to treat it. 

Actually, the output should be "EN_Unkwown", for example

So, for each French entry (first segment), I need 3 translations. Is there a solution that could solve this?

Thank you again for your help.

Sophie Martin 

Can you post the actual content of a short sample instead of a screenshot so we don't have type one up ourselves?  Also a sample of what the end result should be as I'm not confident I understand you properly and don't want to waste time guessing.

Result should be (automatic translation)

 Sophie Martin 

You said:

Sophie Martin said:

source column 3, target column 5

In this new example you only have four columns in the end result?

But this explains it better for me... thank you.

The least technical way is probably this:

1. import to Excel, hide the rows with the language IDs you don't need.  So to translate into English (2) hide rows 1, 3 and 4.
2. hide columns 1 and 2
3. open in Studio and handle with the standard Excel filetype
4. repeat for the other languages

Out of interest, and because AI is my goto tool for anything I think might be an interesting test, I asked ChatGPT how to prepare the file in Excel as you don't want to have to keep clicking on each row one at a time.  The solution presented was this:

First of all save your Excel as an "Excel Macro-Enabled Workbook (*.xlsm)".

You can then create a Visual Basic for Applications (VBA) macro in Microsoft Excel to hide rows based on the value in column B. To do this, follow these steps:

1. Press ALT + F11 to open the Visual Basic for Applications (VBA) editor.
2. Click on Insert and then select Module from the dropdown menu to insert a new module.
3. Copy and paste the following code into the module:
   

   Sub HideRowsBasedOnColumnB()
   
       Dim ws As Worksheet
       Dim rng As Range
       Dim cell As Range
       
       Set ws = ThisWorkbook.Worksheets("Sheet1") ' Change "Sheet1" to the name of your worksheet
       Set rng = ws.Range("B1:B" & ws.Cells(ws.Rows.Count, "B").End(xlUp).Row)
       
       Application.ScreenUpdating = False
       
       For Each cell In rng
           If cell.Value = 1 Or cell.Value = 3 Or cell.Value = 4 Then
               cell.EntireRow.Hidden = True
           Else
               cell.EntireRow.Hidden = False
           End If
       Next cell
       
       Application.ScreenUpdating = True
       
   End Sub
   

4. Replace "Sheet1" with the name of the worksheet you want to apply the macro to.
5. Press CTRL + S to save the macro.
6. Press ALT + Q to close the VBA editor.

To run the macro, follow these steps:

1. Go back to your Excel workbook.
2. Press ALT + F8 to open the "Macro" dialog box.
3. Select the macro named HideRowsBasedOnColumnB and click "Run."

The macro will now hide all rows where the value in Column B is 1, 3, or 4.

You can easily edit this to suit the languages you need after that.

Well, thanks a lot for your precious help, Paul. 

I'll give it a try tomorrow. 

Just one more question. I'll finally get a file per language. Is that right? How can I "merge" them all without copy/past to get the final file the client hopes to get? 

Sophie Martin 

If you are not doing the work sequentially then you will have a file per language.  So short of developing a technical solution to merge them the easiest way is probably to wait until you get all your translated files back and then just create a new project for FR-NL using the translated EN file.  Pre-translate it or Perfect Match it against the FR-NL project you created earlier.  Save the target file.

Now using that target file create a new project for FR-DE.  Pre-translate it or Perfect Match it against the FR-DE project you created earlier.  Save the target file and job done... this target now contains all the translations in one file.

Sophie Martin 

If you are not doing the work sequentially then you will have a file per language.  So short of developing a technical solution to merge them the easiest way is probably to wait until you get all your translated files back and then just create a new project for FR-NL using the translated EN file.  Pre-translate it or Perfect Match it against the FR-NL project you created earlier.  Save the target file.

Now using that target file create a new project for FR-DE.  Pre-translate it or Perfect Match it against the FR-DE project you created earlier.  Save the target file and job done... this target now contains all the translations in one file.