LOD Support Webinars - Shared screen with speaker view
Can you Concatenate on rows as well?
That is exactly what I needed to know. :-) I am flipping others data and it came in as different formats. THANK YOU!
is there a difference between concatenate and merge?
I have used this when collecting references for 4-H Camp Counselors. The Qualtrics survey shows all of the answers for a single counselor in one row. I transposed that data to create a column of the answers. By stacking the 3 columns for each counselor next to each other, I can print one page that summarizes the 3 references for each counselor.
Teresa K. Sallee SNAP-Ed
Great information. Thank you!
If you have addresses, how do you do a mail merge for labels?
Concatenate rather than merge allows you to keep both sets of data and increases your sort flexibility. Sort by last name, but print with a concatenated column to take up less space when printing.
That’s a great idea Kay!
@Katie I can get you a resource really quick.
^^mail merge documentation