I have raw data that is horizontal in a worksheet. I need to pull it into a
report, and it needs to be vertical. For example, data is in A1, B1, C1, D1,
E1 ..... In my report sheet I enter ='Raw Data'!A1. I then try to copy my
formula vertically but it copies vertically from my data sheet. When I make
the row absolute by adding $ it still copies vertically even though I leave
the column as relative. I have a lot of data and it takes too long to do one
at a time. Any help would be appreciated. Thanks!