Formatting a lookup for wedding invitations

Hey guys,


I'm usually considered an Excel wizard in the office, but I have no idea how to do this one.


I've got a list of attendees and their addresses. I'm going to be hand-writing the envelopes and doing some calligraphy. What would make my life easier is if the information wasn't displayed as:
But instead:


I can do that much just by referencing the cells, but I can't figure out a way to move each cell down a row without manually changing all the 1's to 2's.


Anyone have any ideas?!


Thanks!

Do you mean like this?

Excel 2016 (Windows) 32 bit

	A​	B​	C​	D​	E​	F​	G​	H​	I​	J​	K​	L​	M​
1​	Name	Address 1	Address 2	Address 3		Name	Name	Name	Name	Name	Name	Name	Name
2​	Name	Address 1	Address 2	Address 3		Address 1	Address 1	Address 1	Address 1	Address 1	Address 1	Address 1	Address 1
3​	Name	Address 1	Address 2	Address 3		Address 2	Address 2	Address 2	Address 2	Address 2	Address 2	Address 2	Address 2
4​	Name	Address 1	Address 2	Address 3		Address 3	Address 3	Address 3	Address 3	Address 3	Address 3	Address 3	Address 3
5​	Name	Address 1	Address 2	Address 3
6​	Name	Address 1	Address 2	Address 3
7​	Name	Address 1	Address 2	Address 3
8​	Name	Address 1	Address 2	Address 3

If so, select A1 to D8, then copy and paste special - transpose.

Well, I'll be. That's exactly what I wanted! Thank you!