Data merge should work better with % - empty fields
when working with factsheets it occurs that there are fields of text that need to be merged. Whenever there is a special character the function doesn't work. This is very very very annoying. It is quite common to use % in text, or brackets (like this)
Also it should be possible to have a blank cell in the excel merge file. E.g. for 45 lines there is info, but for 1 there isn't. This should be able to be left blank and not obliged to fill in a 0 that you manually need to delete later on.
Merging happens for more than letters and product numbers...........
InDesign lacks for data merge features for years (unfortunately). Please Adobe - have a look on MyDataMerge on mac. This is how data merge should work.