I have looked up this same question so many times. This is the first video that has actually helped! Thank you!
@cheezeandcrackers
7 ай бұрын
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?
@youasterix
Ай бұрын
Gracias Chester!! excelente información.
@LuciaSnoei
2 ай бұрын
Dang. So clear! Thank you.
@andrieswilhelmusroesch4667
8 ай бұрын
This was amazing and saved me a lot of work, thank you very much
@djl8710
Жыл бұрын
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,""))
@erhaneren2122
10 ай бұрын
Great job. 👌
@drenfreezy6614
Ай бұрын
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.
@dieselfox9879
Жыл бұрын
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.
@AndreaGarcia-rp1wy
11 ай бұрын
Any answer to this question.
@AjaykrishnaRA
9 ай бұрын
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.
@cesarvillegas3531
8 ай бұрын
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.
@PFunk-kt9gc
6 ай бұрын
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.
@onbeingattached
11 ай бұрын
Thank you. How do you remove duplicate data that shows up like "X, X, X"
@manishapanda9988
Ай бұрын
I have value in different column how to do it
@anthonynaughgle3616
Жыл бұрын
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.
@vidsbyme2590
7 ай бұрын
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.
@catecce3028
Жыл бұрын
Thanks
@OferiaFirchaYenisSaputri
Жыл бұрын
thank you, it's help me a lot
@iamteeten
Жыл бұрын
Hi sir need your help badly....
@Tanya-zc7ro
Жыл бұрын
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
@arrianranger5800
9 ай бұрын
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
@IvanCortinas_ES
Жыл бұрын
Yeah. Solid explanation Chester. Excellent resolution with Power Query using Text.Combine. Thank you!!!
@franckhermann9071
Ай бұрын
Thank you so much. Does it work also with numbers.
@BankerWriterMosharaf
8 ай бұрын
Please make a video on how to replace series of Duplicate Values with Blanks / Zeros while retaining the first occurrence or last occurrence
@abdessamadchokri352
7 ай бұрын
with this Power Query , You just save my life, Thank youu!!
Пікірлер: 33