How to change an array of data

D

Diviseuk

I am searching for a simple way to change a column of data (numbers) from a vertical layout to a row in a horizontal layout.

Does anyone know how I can do this in Excel
 
F

Frank Kabel

Hi
maybe this will do
1. Select the column and copy them
2. Select your target row
3. Goto 'Insert - Paste Special' and choose 'Transpose' as option

HTH
 
H

humejap

Use copy and then Paste Special and check Transpose, just make sure tha
when you select the range to paste to, you select the same number o
columns as there were rows in your original selection and the sam
number of rows as there were columns
 
Top