ROW TO COLUMN

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.

dataset.xlsx

ACTUAL.xlsx

Datasets

Common Use Cases

Accepted answers

AbhilashR

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.

All comments

AbhilashR

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

sample.yxmd

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

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703