Transposition of Text Data Assistance Needed

[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

[schoujar]

Where is the attached sample spreadsheet?

[JMB]

Try copying the data,move the cell to another location, then click on
Edit/Paste Special and check transpose.

"rmoreno" wrote:

>
> 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
>
>
> --
> rmoreno
> ------------------------------------------------------------------------
> rmoreno's Profile: http://www.excelforum.com/member.php...o&userid=27307
> View this thread: http://www.excelforum.com/showthread...hreadid=468108
>
>

[rmoreno]

Sorry about forgetting the file attachment. Please forgive the oversite.