Simple Mysql query

Job ID: 32091914

Budget: £10 – £20 GBP

This is a very simple project, in reality, a question.

I have a table called table1

# user_id, email, identifier, value
'1, 'myemail@email..com', 'firstName', 'john'
'1', 'myemail@email..com, 'lastName', 'doe'
'2', 'myemail2@email..com', 'firstName', 'Bob'
'2', 'myemail2@email..com', 'lastName', 'Builder'


I need help from a Mysql expert to return the results on a single row as:

user_id, email, first_name, last_name

So it needs to extract the fields from firstName.value and lastName.value into new columns.