ROW TO COLUMN

[razzy]

Hi everyone,

Hope everyone is keeping safe, i need help with transforming this dataset attached. Ideally i would want my coulmns to look like what i attached as " actual" in the sense that i want to make a the following transformation in the column field labelled name to be

"ID", "recorded_time" , "value" , "time"

For every ID that has unique values to all these fields in the data set these value are reported as the in the sheet "actual".

Please ignore the 400 values generated in the ID field the ID is the same in the data set for every unique entry.

Thanks in advance.

[AbhilashR]

Hi @razzy, give this workflow a try and let us know if this satisfies your ask.

[razzy]

Thanks for responding, almost there but the value of the recorder time for each ID uniquely for times 1 through 6 is the same but in the workflow output it is not consistent

[AbhilashR · Accepted solution]

In other words the RECORDED_TIME date is the same for a given ID? If yes, then just delete the Multi-row formula tool I had in my original workflow.

Your sample output had inconsistent dates for a given ID which confused me.

[razzy]

Thank you very much, its perfect!!!!

Thanks again