rmoreno

Hello, I have a computer controlled instrument that collects information like temperature, humidity, rain fall, and time data was taken. This information is collected and reported by date.

What I have been trying to do is transpose the data so that it can be more easily graphed.

I have attached a sample spreadsheet which shows how the data is when I receive it and and how I want the data to look when the formula or VBA is finished analysizing it.

I have been working on this for days and cannot come up with a solution. Can anyone offer any suggestions or help please?

Thanks

webbone

You seem to have missed the attachment - and you would probably be better off with just attaching a couple of screen shots as an .xls will likely not be allowed due to potential for macros, etc.

Timbo

xls files are allowed as long as the code is viewable, however attaching a screenshot would probably be just as effective in this case.

NateO

Hello,

As a wild shot in the dark, I assume you want to pivot your data versus transposing it, like a Crosstab query. Not knowing for sure, I'll offer up the following resources for you to review:

http://www.cpearson.com/excel/pivots.htm

http://www.contextures.com/xlPivot01.html