Logo

LOD Support Webinars - Shared screen with speaker view
kaser.37
01:04:15
Can you Concatenate on rows as well?
kaser.37
01:05:04
THanks!
kaser.37
01:06:34
That is exactly what I needed to know. :-) I am flipping others data and it came in as different formats. THANK YOU!
Carrie Vollentine
01:07:59
is there a difference between concatenate and merge?
Kay Kramer
01:08:02
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
01:08:12
Great information. Thank you!
Katie Cole
01:09:06
If you have addresses, how do you do a mail merge for labels?
Kay Kramer
01:09:10
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.
Brian Butler
01:09:23
That’s a great idea Kay!
Amy Kohmetscher
01:10:00
@Katie I can get you a resource really quick.
Katie Cole
01:10:33
Perfect!
Amy Kohmetscher
01:10:59
https://support.office.com/en-us/article/mail-merge-using-an-excel-spreadsheet-858c7d7f-5cc0-4ba1-9a7b-0a948fa3d7d3
Amy Kohmetscher
01:11:09
^^mail merge documentation