3 Replies Latest reply on Jul 21, 2015 1:48 PM by Peter Spier

    Using the excel column/data merge header as data merge text

    mcusim3

      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,

      Mike