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
