with t as
(
 select
  cast(event_data as xml) as event_data
 from
  sys.fn_xe_file_target_read_file(N'C:\tmp1\TestSession*.xel', null, null, null)
)
select
 e.n.value('(action[@name = "sql_text"]/value)[1]', 'nvarchar(max)') as FirstColumn,
 e.n.query('.') as SecondColumn
into #Session
from
 t cross apply
 t.event_data.nodes('/event[data[@name = "wait_type"]/text/text() = "LCK_M_X"]') e(n)

 select FirstColumn, SecondColumn.value('(/event/@timestamp)[1]', 'nvarchar(max)'),
 SecondColumn.value('(/event/action[@name="client_app_name"]/value)[1]', 'nvarchar(max)'),
  SecondColumn.value('(/event/action[@name="session_id"]/value)[1]', 'nvarchar(max)'),
    SecondColumn.value('(/event/data[@name="wait_type"]/value)[1]', 'nvarchar(max)'),
        SecondColumn.value('(/event/data[@name="wait_type"]/text)[1]', 'nvarchar(max)')
 from #Session
 order by SecondColumn.value('(/event/action[@name="client_app_name"]/value)[1]', 'nvarchar(max)')