MrExcel Publishing
Your One Stop for Excel Tips & Solutions

transposing info


Posted by Scott A on July 07, 2001 3:21 PM

I have date listed like:
A........B
Name.....Driver
.........Driver
.........Driver
.........Driver
Name.....Driver
.........Driver
.........Driver
.........Driver

I want to put the info like this:

A.........B........C........D........E........

Name.....Driver.....Driver.....Driver......Driver
Name.....Driver.....Driver.....Driver......Driver

I use Transpose as an array formula, but when I sort the rows by Name, I lose the original Transpose Cell
references........Is there a way around this?
Scott



Posted by Scott S on July 07, 2001 10:37 PM

When you enter your transpose formula, make the cell refrences absolute (add "$"). Then when you sort, it should work. .....Driver.....Driver......Driver