Importing or Paste One Column Data and needed in rows

[RogerP]

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel Here is the data problem when I paste a copied contact from a list:

A1 has Company
A2 has Name
A3 has Address
A4 has City

I want to make A2 >B1 when pasting
I want to make A3 > C1 when pasting and so on

Ha someone got a simple paste or import solution as the import wizard doesn't solve the problem

Roger

 

[mysci]

Try Edit-->Paste Special
Check the box that says transpose.
Click OK

 

[RogerP]

Great - many thanks mysi

Will save me hours

 

[brinded]

What if I want to transpose cell references?

eg if a column contains values in N1, N2, N3, N4 ....

and I also want those values to appear in a row as C8, D8, G8, H8, H9

I would select cell C8 and type "=N1"

Ideally I could just select/drag across the row and the references
would follow automatically, unfortunately that's not the case - it
wants to work in the same direction as the dragged row, not the
sourced column.

Any ideas?

 

[CyberTaz]

No offense,but I honestly can't conceive of any reason why anyone could
possibly need to do this. If you fully describe what it is that you're
attempting to accomplish perhaps there is an alternative approach.

If you really must do this, here are 2 approaches;

If you just want the content of N1:N8 copied to C8:K8, select & copy N1:N8,
right-click C8, select Paste Special, tick the Transpose checkbox, then OK.

If you need formula references in C8:K8 it's a bit more involved:

1- In O1 enter =N1, use the fill handle to O8, leave those cells selected,
2- Key Control+U, then Command+T, then return,
3- Repeat Step #2 for each of the cells in column O, then copy those cells,
(Steps #2 & 3 convert the formula references to Absolute)
4- Right-Click C8 & use Paste Special> Transpose as above,
5- Select & clear cells O1:O8.

HTH |:>)
Bob Jones
[MVP] Office:Mac