I have two columns and I want to paste the first value in the first column into another column and then paste the first value in the second column underneath (transpose) the first value in the new column Basically tranpose...many thanks...not an expert in excel

# Transpose two columns

## Answers

I am attaching a spread sheet with 2 solutions: 1. uses formula in Cells C1 & C2 that needs to be copied down (use fill handle & make sure you copy down to an EVEN number of cells that is 2 times your original size (Example if your 2 columns ended at row 12, you would have to copy down to row 24). In cell C1 enter the formula: =INDIRECT("A"&INT(ROW()/2)+1) and in cell C2 enter formula: =INDIRECT("B"&ROW()/2). Then highlight these 2 cells and copy down to double the original range (as described above);

Solution 2: Basically addes 2 helper columns in front of your data in Column A & Column C (see Solution 2 tab); The first column A will be ODD Numbers starting with 1; The other helper column (Column C) will have EVEN numbers 2,4,etc. ~ use Data Fill in increments of 2 to accomplish these! Then copy data to say Column F & G, Put your original 2nd column of data with helper column below the ODD Numbers. Then sort on the new Range.

Best of luck. Please give credit if either of these solved you issue.

Assuming that your data is in Column A & B: Copy (highlight the 2 columns), then move over to say column G (cell G1), then use Paste Transpose. The data now should appear in the 1st & 2nd rows in column G. If it looks good (if it transposed to what you expected....then you can delete columns A& B.

### Discussion

9 8

9

8

PARENTDISC 0.563 (0.137) BLACKW1 -0.435 (0.499) AGE1 0.363 (0.086)

And what I want to do is have it look like. So the values of the second column go under the corresponding values of the first column.

.563

(.137)

-.435

(.499)

etc....I hope this is clearer

0.563*** (0.137) -0.435 (0.499)

9 8

4 5

3 6

and I want to place the values of the second column under the values in the first column

The new column would look like

9

8

4

5

3

6

I know I can do this by copy and pasting via transpose. But the columns have a large amount of data so I think I need a macro that will do the cut paste and transpose so I end up with one column.

many thanks....