Forum Discussion
Matching Excel cells by column
Hi, I'm trying to do what I thought was a simple match, but it looks to be a little more complicated than I thought. I have two lists, each with their own column & respective ID #. For example, "...
It's always better to upload a sample file to get a quick help and discard any confusion. This helps to visualize the end result you are trying to achieve.
Anyways, if you have access to dynamic array formulas, you can try the other solution above, otherwise you can try the following macro to get the desired output which you showed in your original post.
Sub TransformData()
On Error Resume Next
Range("A:D").SpecialCells(xlCellTypeBlanks).Delete shift:=xlUp
End Sub
