OK I seriously need Excel help, this will make my life easier, I know what I want to do but not how to do it, and it should be something that is possible. There is a sample of my spreadsheet below with only 3 rows and 6 columns, columns A, B and C are a range in a specific sort order that I don't want to change, columns D, E and F are basically the same data with more or less info attached that was exported from a SQL database and I need to make columns D, E and F match coumn A, can this be done?? If anyone's still with me then here's the tricky part, keep in mind that there may be more or less data in column A that is not in column D which means that if I build a custom sort order and sort D using a custom sort order of column A, the sort does work but the rows for D don't necessarily match column A and I want them to match so if there were a value for A that wasn't in column D list then I want a blank line to be put there. If I was as clear as mud and someone has a solution I would really appreciate it.
RA4062256 BARAGONA_L 5424-151 RA3343435 268443 SILICONE
RA4062287 BARAGONA_L 5424-151 RA3343436 268444 SILICONE
RA4062254 BARAGONA_L 5424-151 RA3343441 268449 SILICONE
RA4062256 BARAGONA_L 5424-151 RA3343435 268443 SILICONE
RA4062287 BARAGONA_L 5424-151 RA3343436 268444 SILICONE
RA4062254 BARAGONA_L 5424-151 RA3343441 268449 SILICONE