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?

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.