Copy columns to rows????

[Jacob Hilderbrand]

Make sure that the cells in question are not Merged.

• Select the cells

• Format | Cells... | Alignment

• Uncheck Merge cells

• Ok

[Ismael]

The cell aren't merge I think is because EXCEL doesn't transpose empty cell, so for example if we have a range in the macro for entire column b, but the values stop at b500 excel will return an error, a said that because I try to do the same thing manually now an EXCEL return the same message.

But now I have another problem, when I asked the question I forget one thing that are:

instead of values in one column I have values in 2 column for example column A and B, and what I want to do is

if in A2 is hjk and B2 is 2, and A3 is ert and b3 is 5, I want to write in

c5 hjk, d5 2, e5 ert and f5 5.

I think that will complicate a little bit the problem right?