How to transpose then move cell locations so it prints correctly

[miken54]

Hi All, I don't know what keywords to search online for, so I figured I'd ask here. A co-worker of mine is old school and she takes data from excel, then has to manually hand-write customer information on separate sheets of paper to submit rebates to vendors. I only listed 4 examples below but there are hundreds a month.

[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]NAME[/TD]
[TD]ADDRESS[/TD]
[TD]CITY[/TD]
[TD]STATE[/TD]
[TD]ZIP[/TD]
[TD]PHONE[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]ALAN BAKER[/TD]
[TD]123 MAIN ST[/TD]
[TD]New York[/TD]
[TD]NY[/TD]
[TD]10001[/TD]
[TD]212-555-2000[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]JOHN STONE[/TD]
[TD]45 W 3RD AVE[/TD]
[TD]Queens [/TD]
[TD]NY[/TD]
[TD]12006[/TD]
[TD]646-555-1010[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]CHRIS BLACK[/TD]
[TD]19 4TH AVE APT 5[/TD]
[TD]BROOKLYN[/TD]
[TD]NY[/TD]
[TD]13000[/TD]
[TD]646-555-5000[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

My goal would be to stick the vendor form in the printer and then adjust where this customer information shows up in a cell range so when its printed, the name will show up in the correct spot on the vendor form.

So, Is there a way to transpose this so that it shows up looking like:
Alan Baker
123 Main St
New York, NY, 10001
212-555-2000

But then have this info be placed in a different cell (say the first customer information gets placed into cell i45 for the customer name, i46 for the address, etc) so that when I print all pages, the customer information prints in the correct spot). The second set of customer info would be placed in i97, so on and so on.

I am not sure if I explained this properly but any help would be appreciated.

 

[Chrisdontm]

You could use the paste special for transposing things...

Try on a small amount first;

Highlight the range of information,
Right click and copy,
Then go to another sheet,
in cell A1 for example,
right click and slide down to paste special, then slide over to the one that brings up the screen tip " Transpose (T) "
Then click it and all of your info will be transposed...