Problem Transposing a column of Data

[Impartial Derivative]

Hey Guys,


I have large sets of data that are sorted by unique numbers or tags. These numbers are listed in column D but do to large amounts of repetition I have excel report only the unique values in column I (starting in cell I4). In order to analyze my data I am trying to construct a table, thus I would like to copy this entire range of unique values in column I and transpose them horizontally across the workbook starting in cell J3. Previously, with my smaller testing data sets I was able to select cell J3 and then simply use paste-->special-->transpose. However, yesterday when I tried a larger data set Excel generated an error saying that the paste area needs to be the same size as the column selected and copied in order to complete the transpose. This is the first time I've run into this issue with this particular code and after trying a few small tweaks in my code, nothing seemed to solve my problem. Are there any quick ways to avoid this error and transpose a dynamic selection? Thanks again and feel free to ask questions if I need to clarify any details.

Cheers,

Impartial

[StephenR]

Is it possible that you have more rows of data than columns in Excel?

[snb]

Please Login or Register  to view this content.