Transpose-have a .csv file

[RTA]

I have a .csv file which is a logged data has the format shown below

Time Value
X1 y1 z1
X2 y1 z2
X3 y1 z3
X4 y1 z4
X1 y2 z5
X2 y2 z6
X3 y2 z7
X4 y2 z8
.
.
.
.
I want to convert as shown below and create a chart by programming

Time X1 X2 X3 X4
y1 z1 z2 z3 z4
y2 z5 z6 z7 z8

This formatting should be done as soon as the file is open.

[mrice]

Try this macro.

Please Login or Register  to view this content.