Using Transpose in excel

**ageless** · 03-17-2009, 02:23 PM

I have been using transpose to change from columns to rows.

Lately, when I transpose, I get a completely different and unrelated series of references.

eg: I copy a15:a21 I then highlight the destination cell and click on transpose.

Now, comes the fun part, I will not get a15:a21 but something completely different. they will be a series, but not even close to what I wanted.

Any ideas??

**NBVC** · 03-17-2009, 03:05 PM

Did you try selecting Values as well as Transpose when you Paste Special your range?

**ageless** · 03-17-2009, 03:15 PM

I just tried again.

Don't understand selecting values. I highlight the cells I want to copy.

These cells are in a column.

When I transpose, the cells are completely different cells with no correlation to the selected cells.

**NBVC** · 03-17-2009, 03:38 PM

How were the values in the original cells obtained? Are the hard-coded numbers or are they results of formulas... if the latter, what is the formula?

Better yet, post the sample sheet so we can take a look.