Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Pivot... then what?

Hi, I have a large data set with X,Y scatter data.   Unfortunately its in the format single rows for each experiment, then columns for each of the 124 data points on each axis.  E.g.   ID        D1...
Need Help
Sansudhi8's avatar
Sansudhi8
Helper III
7 years ago

Dear Anonymous,

 

Please try following steps and see the attached. I haven't clear idea of your requierment. 

 

PBI.

 

 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi Sansudhi8

 

Thanks for getting back to me.  I couldnt make much sense of what you sent through (probably my faul) so here's a more thorough description of what i'm after.

 

I have data in this format:

 

 

I would like to change it to a format where I can plot D vs F for each set of data, e.g. ID898, 899.

 

I'm assuming in order to do this i'll require a format like below:

 

 

Where rows 2, 3, 4 and 5 are the data for columns D1-4 and F1-4 from above.  Does this make sense?

 

Thanks