Asset location change(Transfer from one location to another location)

Hi Team ,

I want change the asset location (Transfer to another location).

I have tried these two ways.

Step-1. Asset workbench --> Assignments.

But I have thousands of records so its not possible. 

Step-2. Mass Transactions --> Transfer

Here I cant see Asset number, Based on category only I have to transfer.

Note:- My Idea is in this Spare 2 and Spare 3, I will add all assets and Units. pls suggest.

Thanks,

Ramesh