Combine Line Items From Columns/List

I'm trying to consolidate three (sometimes more) years worth of unique/duplicated P&L line items...If I pasted them all in one columnn on top of one another and filter by unique values, it places them at bottom, and I have to manually place unique ones back in their spot. Below is basically what I'm dealing with:

Year 1
X expense
Y Expense

Year 2
A Expense
B Expense

Year 3
Q Expense
A Expense
Y Expense

I want to turn it into a consolidated list over the three years so it would look like this:

A Expense
B Expense
Q Expense
X Expense
Y Expense

I've tried a couple formulas to no avail, is VBA the only way?!

Thanks a bunch guys. Looking forward to your thoughts!

Attached. Took out other stuff; just raw data.

Just wish I could merge the columns together and place the unique values in their spot on aggregated.

Do you just want one list of unique values? Data > Remove duplicates can achieve this.

It's great...but again, it places these at the bottom because they change position and it's obviously not where they belong:

Discounts
Commercial
Finance Charge
Interest Expense - Other
Officers' Compensation
Legal Fees
Security System
Property
Cleaning
Construction Expense
Reconciliation Discrepancies
Safety Coordinator
Trash/Toilets
Gain or Loss on Sale of Assets

What do you mean by "obviously not where they belong"?

Net Income is last line in all three- where it belongs.

Those 14 unique ones that filtered to bottom do not belong there.

i.e. - discounts belongs way up in its expenses, where it's kind of 'grouped'. Look at the 401K line..that made it to its appropriate spot. I feel like it gives priority to the top-most list?

I have no idea.

Okay. A2:D4 are the same. Easy peazy. A5, B5, and C5 are all different, but on the same row. How are we to know the order they should be listed in?

See attached.

We can't believe it. Happiest office in New York right now...how did you do that!?

Some manual manipulation with the help of an add-in.

Was lining the items (inserting rows so they even out) all manually/eye-balling!? Very interested in add in too

It took maybe 5 minutes. The add-in is Kutools, which provides a lot of VBA functionality by simply clicking buttons. It's pretty helpful. I wouldn't be surprised if it could actually have done the whole thing automatically, I'm just not super familiar with it.

But in general, if there's a task you do on a regular basis (e.g., daily, weekly, etc.), then it might be worthwhile to spend hours or days trying to find the most efficient way to do it. But if you've got a one-time problem, sometimes the tedious/manual solution is the way to go. I got too annoyed trying to figure out the most efficient way to do it, so I just did it manually. But check out ku-tools.

Is it a lengthy explanation? I like how you added the rows in between, and then did you merge?

I downloaded Kutools...compare ranges? I maybe just need to sit & play with it...lost

I manually inserted cells so everything lined up and any unique items were in rows by themselves. Then used kutools to fill in blank cells pulling to the left. There may be an easier way to do it with kutools. I'm not too familiar with all their functions.