Picture my brochure. The first column will have the "title" of the row (ie: length overall). The second column will have length in Meters. The third column will have length in feet. Now, when I data merge I want to automate all three columns; however, because the first column is not a data value in excel but instead the column header, I cannot figure out how to use the data merge title as a cell. For example, my second column might be <<LOA (M)>> and my third, <<LOA (Ft)>> can I automate so that the first column says LOA.
Thanks for any help in advance,
For data merge, the entire first row of the data file must be the filed names, so add a row and give the first column a name...
I don't think that will work. It has to be an automated process because I am extracting a csv from access and importing into indesign. Therefore I have to format the indesign template for an untouched csv
You don't have a choice. Data merge uses the first row of any data file you give it as the field names, so every column must have a non-null value in the first row, and that value must be the name of your field for the placeholder. You can have null cells after the first row, but not in the first row, and any data you want merged must be in a row below row 1.