many Rows per user to 1 row per user

[ValR82]

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

[binuacs · Accepted solution]

@ValR82 Are you looking something like below?

[vlad_kutateladze]

Hi @ValR82 

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

[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.

I need each response to be in its own cell and need to be able to rename the cells so that they don't just say vehicle, vehicle  1, vehicle 2 etc

i tried using text to columns but it wants a specific number of columns for the split - i cannot specify this.

[Emmanuel_G]

Hi @ValR82 ,

Find a really simple to use test below.

You can edit the value of columns in text to columns as you want. I put a cleasning data tool to delete useless fields after. 

I hope that answers the question you are asking.

If not, you can post a preview of the output you want.

Let us know if it works.

Cheers !

[ValR82]

Thank - i amended this slightly but it worked!