Oracle unpivot of table data
Select FirstName, LastName, Date_1 as date, City_1 as city, State_1 as state
  From performertours
Union all
Select FirstName, LastName, Date_2, City_2, State_2
  From performertours where date_2 is not null
Union all
Select FirstName, LastName, Date_3, City_3, State_3
  From performertours where date_3 is not null
Union all
Select FirstName, LastName, Date_4, City_4, State_4
  From performertours where date_4 is not null