many Rows per user to 1 row per user

Hi all

am after some help, i have a very large dataset where there may be many rows per user, column A and Column B will remain unchanged across that user information (many rows).

I need to put all the information in the rows into 1 row per user so A, B and then C, D for all the rows that exist for that user (column A).

Hope this makes sense. Please see example data input attached.

Thank you in advance

DataSet.xlsx

Tips and Tricks

Accepted answers

binu_acs

@ValR82 Are you looking something like below?

one_Row_per_person_11_07.yxmd

All comments

binu_acs

@ValR82 Are you looking something like below?

one_Row_per_person_11_07.yxmd

vlad_kutateladze

Hi @ValR82

You can group data by column A and Column B, and all other columns concatenate.

many Rows per user to 1 row per user.yxmd

ValR82

Thank you both for such prompt replies, i have got this far, my issue is that i need each answer to be in a separate cell in the output but some users will have 4 cars and 3 houses and some only 1 car and no house.