Multiple rows with different atributes into multiple columns

[gmiro]

Hi all,
I have a data stream with multiple rows with different parameters for the same timestamp:

I'd like to transform it into a unique table with columns as parameters for the same timestamp.

I've been looking for the different examples for multiple rows combination but no luck. Thanks!

[Jihwan_Kim · Accepted solution]

Hi, @gmiro 

Please try the below in Power Query Editor.

- select Parameter Column

- click Pivot Column

- select Value as Value-Column

- Click

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

OK

[Jihwan_Kim · Accepted solution]

Hi, @gmiro 

Please try the below in Power Query Editor.

- select Parameter Column

- click Pivot Column

- select Value as Value-Column

- Click

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

OK

[gmiro]

Hi Mr Kim @Jihwan_Kim 

It gives me an error: DataFormat.Error: The input provided as a DateTime value could not be parsed. Details: 20.

I've also tested with datetime as a text with no luck.

[Jihwan_Kim · Accepted solution]

Hi, @gmiro 

Thank you for your feedback.

It worked fine on my Power Query Editor.

If it is OK with you, please share your sample pbix file, then I can try to look into it.

Thank you.

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

[gmiro]

Hi Mr Kim @Jihwan_Kim 

I've started from scratch and it worked thanks!