I have a spreadsheet with an export of data from a system, this data is stored as a row of information per instance. Some cells contain multiple pieces of information split by line brakes. Is it possible to convert line brakes in a cell into new lines so I could use this as data for a pivot table? Or is there any other way of analysing this data? Thanks in advance.

Current format:
Name      |Service     |Value     |Quality
----------|------------|----------|-------
Ric       |HR          |1         |2
          |ICT         |2         |3
          |BI          |1         |3
----------|------------|----------|-------
Dave      |HR          |2         |4
          |ICT         |3         |2
          |BI          |3         |1
----------|------------|----------|-------
Mike      |HR          |1         |4
          |ICT         |3         |1
          |BI          |3         |2
Ideal format:
Name      |Service     |Value     |Quality
----------|------------|----------|-------
Ric       |HR          |1         |2
----------|------------|----------|-------
Ric       |ICT         |2         |3
----------|------------|----------|-------
Ric       |BI          |1         |3
----------|------------|----------|-------
Dave      |HR          |2         |4
----------|------------|----------|-------
Dave      |ICT         |3         |2
----------|------------|----------|-------
Dave      |BI          |3         |1
----------|------------|----------|-------
Mike      |HR          |1         |4
----------|------------|----------|-------
Mike      |ICT         |3         |1
----------|------------|----------|-------
Mike      |BI          |3         |2