Need Help With Excel/macro!

[Rekin]

Hey peeps,

I need help with my final year project for university but i suck with basic excel/macro coding..

Is there anyone on sau who can help/make a bit of code for me. Probably take you 5mins i reckon.

The problem;

I download and paste a .csv dump from the internet into excel.

Each set of data has 4 row's of information. The amount changes every month. As you can see in the pic, 4 claims are shown out of a list of 140.

I basically want the 4 rows of data to be put into 1 single row for that claim. As shown in the pic below, I only want some of the values.

Would anyone be able to do this for me? I desperately need it so I can continue with my thesis

Im thinking it would involve a simple loop function?

Attached is the xls sheet with 2 worksheets; one with the csv dump and the other with the table template

Thanks all!!

- Patrick

[paulr33]

does the raw CSV include blank rows as ,,,, or does it remove / strip them

what do null values look like " " or ' ' or ,,,

[Rekin]

does the raw CSV include blank rows as ,,,, or does it remove / strip them

what do null values look like " " or ' ' or ,,,

the raw csv is exactly as shown on the screenshot and excel file. All I did was open the .csv in excel.

null values as shown in the excel are just blank cells

Hope that helps

thanks

[Sheriff Wan]

You have PM

Cheers

[Rekin]

You have PM

Cheers

Dude that is unreal!

Thank you very much for that!! Saved my bacon, as I was stuck and couldnt go on with my project because of this silly data.

I owe you big time!!