Swapping columns to rows using formula.

Dear Excel colleagues,
I am having a hard time to rearrange data in 3 columns. COlumn A is a time stamp, B is a tag name anc C is a value that appeard on particular tag at certain time.
Now what I would need is to change column B into row (so it became headder) and column C also to became a row. Time would still be a column A. To me its not that easy as it first looks.
I have uploaded 2 explanation pics with original file and the target file. Not sure if its visible though...
OriginalFile.png TargetFile.png

Hi

Suppose your data in A1:C25 (with headers)

Use this formula and copy down and forward

Formula:

Please Login or Register  to view this content.

Assume source data is Sheet1, results on Sheet2

Formula:

Please Login or Register  to view this content.

should replicate your results, and assumes headers should be created dynamically relative to dataset.

Thank you guys!!! You cant even imagine how much you have just helped me. I have extremely little time to do this all. I am really really thankfull for this.
I got one more question regarding the formulas. The COlumn A has a certain date format (custom). Of course I can select entire row and change it but last time when I was making different formula I have used this:
(CELL("format";B1)="D4". I have checked the "D4" is the correct code. But as I do not understand your formulas yet and I really do not have much time can you point out where I should place that CELL function ??

I have used this formula for row A: =IFERROR(INDEX(Sheet1!$A$2:$A$13,MATCH(TRUE,INDEX(ISNA(MATCH(Sheet1!$A$2:$A$13,$A$1:$A1,0)),0),0)),"")