F
Frankcw
I trade in the stock market & use excel to convert a list of ticker
symbols to a csv file to import to a charting program. I start with a
vertical list in excel, I copy then paste special & tell it to
transpose. It seems if the list is too long I get an error message:
"The information cannot be pasted because the copy area and the paste
areas are not the same size and shape. Try one of the following:
Click a single cell then paste.
Select a rectangle that's the same size and shape, and then paste"
I assume what is happening is that I don't have enough columns across
to paste the data, sometimes I will have a single column of over 500
rows of data to transpose.
Two thoughts I have is I need a worksheet with more columns or need
the text to "wrap" to the next row. I don't know how to do either.
How do I fix this problem?
TIA!
Frank
symbols to a csv file to import to a charting program. I start with a
vertical list in excel, I copy then paste special & tell it to
transpose. It seems if the list is too long I get an error message:
"The information cannot be pasted because the copy area and the paste
areas are not the same size and shape. Try one of the following:
Click a single cell then paste.
Select a rectangle that's the same size and shape, and then paste"
I assume what is happening is that I don't have enough columns across
to paste the data, sometimes I will have a single column of over 500
rows of data to transpose.
Two thoughts I have is I need a worksheet with more columns or need
the text to "wrap" to the next row. I don't know how to do either.
How do I fix this problem?
TIA!
Frank
