Thanks Chester, I didn't think to try the IF I was using this version since they updated the array grid. =TEXTJOIN(", ",TRUE,FILTER(B2:B20,A2:A20=D1,""))
This is exactly what I was looking for! *except* I have multiple columns that I still need to show. They aren't being combine or anything, but I just need to see them. Is there a way to do that? Thanks so much
Is there a way to do this where each book read drops into a separate column/cell rather than listing all books in one cell? For example, Book 1 column, Book 2 column, etc.
How do we combine rows of information (row a has multiple names some repeating), like you just did, but have the information pulled to another column rather than combine the two? I am looking at a sheet that has multiple rows of the same name but different numbers in each column (column b, c,d etc). I am using mail merge to send out payment reminders but I don't want to have multiple reminders for each payment, would like to have the ability to bull from column a, b, c if they have the same name in column A to c,e,f column. john doe(row 1), $xxxx (column b) $xxx (column c) john doe (row 2), $xoxoxo (column b), $oyoyoy (column c) I want to move row 2 (because it is the same name), column b & C up to column D & E row 1. I have hundreds of rows some have two or more duplicate names.
So after the power query window has opened for the first time. Click on the Books Read column heading. It would choose the entire column. In the home tab, right in the middle of the ribbon, there would be an option named "Data Type: Number". Click on it and a drop down will be opened. Choose 'Text' from the drop down. And then follow whatever the video says. It should work.
Once loading into Power query, go to the syntax and change the integer type “Int64.Type” to “type text” like the other fields. You should be good to continue.
Can this be done using VBA? I would like to combine duplicates in column A and SUM corresponding values in column similar to using the CONSOLIDATION option in Excel.
I keep getting "FALSE, FALSE, FALSE..." any chance you have an idea what I may be doing wrong, my formula is identical (names swapped) as far as I can tell.
This looks like just what I want but the processes and terminology are way over my head. Isn't there a more simple way of doing that. TOOO TOOOO many steps
Gracias Chester!! excelente información.
I have looked up this same question so many times. This is the first video that has actually helped! Thank you!
Merging into a single sell seems like it would be hard to manipulate the data later. How do you combine, but put the data in separate columns?
Yeah. Solid explanation Chester. Excellent resolution with Power Query using Text.Combine. Thank you!!!
Dang. So clear! Thank you.
with this Power Query , You just save my life, Thank youu!!
Very helpful thankyou
This was amazing and saved me a lot of work, thank you very much
Thanks Chester, I didn't think to try the IF I was using this version since they updated the array grid. =TEXTJOIN(", ",TRUE,FILTER(B2:B20,A2:A20=D1,""))
Great job. 👌
This amazing - thank you so much
Thank you so much. Does it work also with numbers.
Thank You!!!
This is exactly what I was looking for! *except* I have multiple columns that I still need to show. They aren't being combine or anything, but I just need to see them. Is there a way to do that? Thanks so much
You just earned a sub!
Please make a video on how to replace series of Duplicate Values with Blanks / Zeros while retaining the first occurrence or last occurrence
so complicated. but i made it. thanks!!!
thank you so much! i made it
Is there a way to do this where each book read drops into a separate column/cell rather than listing all books in one cell? For example, Book 1 column, Book 2 column, etc.
How do we combine rows of information (row a has multiple names some repeating), like you just did, but have the information pulled to another column rather than combine the two? I am looking at a sheet that has multiple rows of the same name but different numbers in each column (column b, c,d etc). I am using mail merge to send out payment reminders but I don't want to have multiple reminders for each payment, would like to have the ability to bull from column a, b, c if they have the same name in column A to c,e,f column.
john doe(row 1), $xxxx (column b) $xxx (column c)
john doe (row 2), $xoxoxo (column b), $oyoyoy (column c) I want to move row 2 (because it is the same name), column b & C up to column D & E row 1. I have hundreds of rows some have two or more duplicate names.
Hi there. This is great! What if the 'Books Read' column is numbers, and I'd like to display the total of the numbers for each person? Thank you.
Any answer to this question.
So after the power query window has opened for the first time. Click on the Books Read column heading.
It would choose the entire column.
In the home tab, right in the middle of the ribbon, there would be an option named "Data Type: Number".
Click on it and a drop down will be opened.
Choose 'Text' from the drop down.
And then follow whatever the video says. It should work.
Once loading into Power query, go to the syntax and change the integer type “Int64.Type” to “type text” like the other fields. You should be good to continue.
Thank you. How do you remove duplicate data that shows up like "X, X, X"
Can this be done using VBA? I would like to combine duplicates in column A and SUM corresponding values in column similar to using the CONSOLIDATION option in Excel.
I have value in different column how to do it
Thanks
I keep getting "FALSE, FALSE, FALSE..." any chance you have an idea what I may be doing wrong, my formula is identical (names swapped) as far as I can tell.
This looks like just what I want but the processes and terminology are way over my head. Isn't there a more simple way of doing that. TOOO TOOOO many steps
thank you, it's help me a lot
Hi sir need your help badly....