Is it possible to make the excel parser write the translated text on a separate row in the same column instead of a new column? Example attached.To write the translation in a new column seems to be very nice and easy, a very good experience, but most often our developers would like to have the translation on a different row in the same column.
No answers? Am I right in assuming this is not possible, then?
You're correct, this is not possible. From the help:
The localization concept is different from solutions offered by document translation tools. The Excel add-in doesn't translate the whole document. It only extracts the content of a selected column and stores the translations into a different column. In addition it supports processing meta data like IDs, length limitations and other properties.
Most common use of a database is that each row has a set of data and the columns represent the attributes of the data. Storing a set of data on multiple rows is not recommended.