data preparation

[sujithgk]

can someone help me prepare data like shown below, input and output.
data to be prepared as shown in the output

so basically i have two columns x and y, x tells the process which has cyclic readings(no fixed number) and y are the readings for x cycle process,

as the processes are not fixed in a cycle , i want to prepare a new table, which has maximum process and all other data readings with different columns for each cycle.

can some one help me with this.

[DavidP · Accepted solution]

Is this what you're looking for?

[sujithgk]

yes exactly, thanks.

[DavidP · Accepted solution]

You’re welcome. Feel free to mark it as a solution to help others on the community who are searching for solutions to similar problems.

[sujithgk]

thankyou