"General" wrote in news:1129837940.963257.5400
@o13g2000cwo.googlegroups.com:

Thanks RP, but that won't quite work. Reason is that the company name
and the quarter are in the same column, not next to each other.

This spreadsheet could be hundreds of companies long, and manually copy
& pasting the company name in a neighboring column would take way too
long. I need the whole entire thing to be automated.

Thanks anyway, please let me know if you have any ideas.

Phil





Phil,

How is this data produced? I did not mean to imply any manual
manipulation of the data on your part.

Ideally the creator of the data could do this for you. If not, we could
use some simple formulas or a macro¹ to improve the structure.

Does anyone else depend on this data? in this format?

Is there anything useful in the empty rows?


-RP

¹policy schmolicy, have whoever doesn't like VBA fix the data then