How to clean this data

[NY2BOS]

Hello everyone the data coming in looks like this 

Product	High User	Value_high	Low User	Value_low
A	James	80
A			John	10
B	Amy	90
B			Tom	20
C	Nicole	40
C			George	10

However it should all be in one row and delete the blank row to look like this 

Product	High User	Value High	Low User	Value Low
A	James	80	John	10
B	Amy	90	Tom	20
C	Nicole	40	George	10

Thank you

[Bobbyt23 · Accepted solution]

You could use a multirow formula for each of the last two columns, like this:

You may need to tweak the first part of the IF statement depending on what is in that cell, blank/space etc.

Or a crosstab and transpose:

[aatalai]

It can also be done with summarise tool