many Rows per user to 1 row per user
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
Solved! Go to Solution.
- Labels:
- Tips and Tricks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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 !
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank - i amended this slightly but it worked!
