How to change an array of data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
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
 
Back
Top