Jun 08 2021 12:25 PM - edited Jun 08 2021 12:26 PM
Hi,
I'm trying to flip rows on a same line if ID of rows the same, can't get it to work, can you guys please help
Here's an exemple of what i'm trying to do
ID1 Product1 Amount1
ID1 Product2 Amount2
ID1 Product3 Amount3
Need to have this way
ID1 Product1 Amount 1 Product2 Amount2 Product3 Amount3
Thank you
Jun 08 2021 03:53 PM
I found this that should help you: https://trumpexcel.com/insert-blank-row-after-every-row/
Once you get a blank in-between each row, try using using the special paste "Transpose" to list out your data horizontally. Do the same with the third column and you should be able to almost interlace the two using paste special combined with the "Skip blanks" paste special feature.
Jun 08 2021 11:05 PM
@Magic115 Since you tagged you post with Office365, I assume you can use the new UNIQUE, TEXTJOIN and FILTER functions.
And if this is a on-time exercise only, consider a simple three-step process to rearrange the data.
Step 1: create a list of unique ID's (assuming your list contains many like in your example)
Step 2: filter all records that match an ID and join it all together in one comma separated text string
Step 3: copy the result from step 2 and paste as values. Then use Text-to-columns from the Data ribbon to split the text into separate columns.
Once you are finished, delete the columns that contain steps 1 and 2 to end up with a list of unique ID's and associated products and amounts.
Now, if you need something more sophisticated, please come back with a realistic sample of your data, omitting any private and confidential information of course.