Importing Badly formatted CSV File

[davidman]

Hi

I have a balance report for holiday hours that each employee has remaining which I can only download as a CSV, unfortunately its set up as below:

Employee - Balance Type - Hours
Dave - VACP - 23
Dave - DVP - 24
Mick - VACP - 2
Mick - DVP - 10.5

Is there a way to get it so that it would be in the format below so that I can create a form which shows employees holiday balances (amongst other things)?

Employee - VACP - DVP
Dave - 23 - 24
Mick - 2 - 10.5

 

[Alansidman]

Here is one solution: Import your CSV as shown. Three queries to get your data as required. Look at the attached.

 

[way2bord]

The CSV is normalized and is good.

I'm pretty sure you can simply import as is, view as a pivot and move your Balance Type to the top.