I am trying to align several different columns in Excel.
My first column looks like this
In addition to that column, I would also have the following:
(the two new columns on the right).
How could I go about aligning those two columns based on the letters (matching them up) while at the same time keeping the same column positions (so the numbers do not move out of the "d" column), the end result being similar to: (forgot to mention, that there may be more items/letters in column a, than what there is in column c)