Return list of multiple records with duplicates

I have a table with over 12000 records. I need to send them to different users. Pivot Table is not an option.
I need each of the users to be able to pull all his own records from the list along with all corresponding records for a different user, if their IDs match.

Example:
User 1 ID 123 California
User 2 ID 123 Florida
User 3 ID 234 Idaho
User 4 ID 456 Alabama
User 1 ID 456 California
User 2 ID 567 Florida
User 3 ID 678 Idaho
User 4 ID 789 Alabama
User 1 ID 789 California
User 2 ID 789 Florida
User 3 ID 678 Idaho
User 4 ID 123 Alabama
User 1 ID 456 Florida

I need User 1 to see all records where it says User 1 along with records of another user where the Ids are the same.
Return for User 1:

User 1 User 1 ID 123 California
User 1 User 2 ID 123 Florida
User 1 User 4 ID 123 Alabama
User 1 User 1 ID 456 California
User 1 User 1 ID 456 Florida
User 1 User 4 ID 456 Alabama
User 1 User 1 ID 789 California
User 1 User 2 ID 789 Florida
User 1 User 4 ID 789 Alabama

Please, help!!!

There is only 1 table with all the record. It has Column 1 User, Column 2 IDNumber, Column 3 Place.

There is a simple way by using another similar spreadsheet: Just group by ID and you'll get what you want. With it, you can also save the file as .xls or .xlsx or txt or html format. See the attched picture: sample.png

It works just the way I needed. Thank you soooo much.
Could you help me to enter If ISERROR part to eliminate #NUM! ?

I tried and is telling me I have too many arguments

Wow!!!
It is the same formula I was entering, but Excell wasn't taking it, until I copied and pasted yours.
bebo021999 you are awesome