My data is hard to transfer (using R). I want to merge rows according to color banding.
Each row of data is set up by color band but within each band it contains multiple rows. I would like to
shrink each color band into a single row. Is there a way to do this or maybe VBA script?
Thanks.