Forum Discussion
Split a column into multiple rows based on time value
Hello,
I have the following table :
table
I would like to merge lines and make one line based on time.
For example :
| 15/06/2020 11:10:46 | VAI-E34 | NO2 Value | Pressure Value | Temperature Value |
Do you know how I can achieve that please ?
Thanks,
Antoine
Hi Anonymous ,
Just as mwegener said, in Power Query Editor, use Pivot column:
1. Select [Parameter] column;
2. Click "Transform" -> "Pivot column";
3. "Value column" choose [Value] column and in "Advanced options", "Aggregate Value Function" choose "Don't Aggregate".
4. OK. Then you'll get what you want.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
Hi Anonymous ,
Just as mwegener said, in Power Query Editor, use Pivot column:
1. Select [Parameter] column;
2. Click "Transform" -> "Pivot column";
3. "Value column" choose [Value] column and in "Advanced options", "Aggregate Value Function" choose "Don't Aggregate".
4. OK. Then you'll get what you want.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
