Hi,

I have a problem that I've spent hours working on but even Microsof
customer support has not been any help.

I'm trying to work with a large data file where the data is groupe
into two types. Let's call them A & B. For each day of data, I have tw
data points, A & B. These are entered next to each other in the sam
row. It looks something like this:

A1 B1 A2 B2 A3 B3 ...

That is, for Day 1, I have data point A and data point B.

I want to be able to easily group all the "A" data and all the "B" dat
separately.

That is, in a separate part of the worksheet, I want to be able t
enter a reference for one of the cells, then highlight that cell an
drag it across a row so that the value of EVERY OTHER column in th
original data set populates the new row. That is, in my newly populate
row, I want to see:

A1 A2 A3 ....

I need the data in this format to graph it.

Can you anyone help?

Thanks,

David


--
dmsalvay197
-----------------------------------------------------------------------
dmsalvay1978's Profile: http://www.excelforum.com/member.php...fo&userid=2680
View this thread: http://www.excelforum.com/showthread.php?threadid=40056