#InDesign CC

# Excel Technique for Data Merge

There are several formulas and techniques that come in handy when trying to normalize data for InDesign Data Merge. Here's a handful of them.

# LOOKUP

# CONCAT

# Force values to stay the same when autofilling