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.