Combine multiple rows of User data into one row with additional columns

[JN]

Dear all,

I have a set of data that contains multiple rows for a person (recording_session_label). I would like to have just one row for each user (recording_session_label) and all data related to that recording_session_label in a separate columns.

My data looks like this. However, it contains a few thousand rows.

I would really appreciate some help. Please let me know if you need further information or data sets.

Best,

JN

[Greg_Deckler]

So you would have the last 8 columns repeated for as many rows that you have that are duplicated for a user?

Generally, that's not a very good idea at all. Why do you think you want to do that?

[JN]

Hello Greg,

Exactly like this. I want to do some spss data analysis and need just one row for each user.

Best,

JN

[Greg_Deckler]

Hmm, I've got nothing. @ImkeF and/or @MarcelBeug might have something.

[ImkeF]

Agree with @Greg_Deckler, this is very un-PowerBI-ish.

How shall your you new column names be? Every column needs a unique name, so do you want a simple number index for each row?

[JN · Accepted solution]

Thank you all for looking into this. A simple number index would be ok.

However, I could also do it manually with a pivot and copy paste. I initially thought this might be easy to code. So, no need to work on it. Thanks again