In order to pull data from an internal source, I have to provide it in a manner where the items are listed horizontally. The original data source is vertical in excel. Usually I take 100 to 200 items at a time and paste special (transpose) them into another sheet.....paste them into a text file, replace all spaces with semicolons and wala it's ready to go. Given that I have a deadline less than a week is there any way to transpose a large quantity (say 1900) at one time??? Let me know!!