Ali,
I'm sorry...I don't think I'm on the same wavelength with you here. Let's put the Power Query thing on hold for just a moment. Let's talk strictly the column with duplicates removed. Even AFTER I remove the duplicates, I still get all those trailing cells. Unless I'm doing something completely wrong, I can't eliminate those extra cells. The only way to remove those cells is by manually selecting the cells that have data in it. Like I said in my previous post, it's easy and it works, but it's time consuming. I currently have 195 artists, which means I have to select 195 cells. Unless there is no other way to do this, and unless this is the only method possible, I'd prefer not to select these cells manually. Eventually, I'll probably have 500 cells.
Now, regarding the Power Query: I'm going to have to study this, learn this, and understand this, because right now, I don't. I'm not at that point yet. Yeah, I probably am making this much, much more difficult than it needs to be, but it's all part of the learning process. Once I get on your wavelength and figure out what you did and how you created the PQ, then perhaps this will all be a piece of cake. Until then, I'm workin' on it!