Jump to content
SAU Community

Need Help With Excel/macro!

Rekin

By Rekin,
in Victoria

 Share

Recommended Posts

Rekin Grand Master

Rekin

Posted
Posted

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.

csvdump.th.jpg

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.

table.th.jpg

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

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!! :thumbsup:

- Patrick

Link to comment
https://www.sau.com.au/forums/topic/265751-need-help-with-excelmacro/
Share on other sites
Rekin Grand Master

Rekin

Posted
  • Author
Posted
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 :stupid:

thanks

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share
Go to topic listing


  • Similar Content

  • Latest Posts

    • bilbo117
      R34 GTR Seats / No longer reclining

      By bilbo117 · Posted

      Hi all, Long time since I've posted here. Looking for some advice on what I can remove to further identify the cause of my issues.  I can move the passenger seat forward and back but the knob used to adjust the seat angle is pretty much free spinning, there's very little resistance.  Removing the side cover I can see that the chain is intact but the shaft for the adjustment spins without the gear attached to it moving.  What's my next step for disassembly here? Is this a common fault? Just being a little cautious as I didn't want to start removing bolts for a spring to fly out or something equally as stupid.  Cheers
    • Dose Pipe Sutututu
      Ethanol Content Sensor - Always at 11%?

      By Dose Pipe Sutututu · Posted

      Those above shitboxes, mediocre and above usually have a turbo strapped to them, hence the slightly higher octane is required.  
    • sinn3r
      R34 Skyline climate control unit transistor

      By sinn3r · Posted

      Hi all,   long time listener, first time caller   i was wondering if anyone can help me identify a transistor on the climate control unit board that decided to fry itself   I've circled it in the attached photo   any help would be appreciated
    • Kinkstaah
      Blue slip

      By Kinkstaah · Posted

      I mean, I got two VASS engineers to refuse to cert my own coilovers stating those very laws. Appendix B makes it pretty clear what it considers 'Variable Suspension' to be. In my lived experience they can't certify something that isn't actually in the list as something that requires certification. In the VASS engineering checklist they have to complete (LS3/NCOP11) and sign on there is nothing there. All the references inside NCOP11 state that if it's variable by the driver that height needs to maintain 100mm while the car is in motion. It states the car is lowered lowering blocks and other types of things are acceptable. Dialling out a shock is about as 'user adjustable' as changing any other suspension component lol. I wanted to have it signed off to dissuade HWP and RWC testers to state the suspension is legal to avoid having this discussion with them. The real problem is that Police and RWC/Pink/Blue slip people will say it needs engineering, and the engineers will state it doesn't need engineering. It is hugely irritating when aforementioned people get all "i know the rules mate feck off" when they don't, and the actual engineers are pleasant as all hell and do know the rules. Cars failing RWC for things that aren't listed in the RWC requirements is another thing here entirely!
    • GTSBoy
      Best place to order Authetic R32 Parts in Japan

      By GTSBoy · Posted

      I don't. I mean, mine's not a GTR, but it is a 32 with a lot of GTR stuff on it. But regardless, I typically buy from local suppliers. Getting stuff from Japan is seldom worth the pain. Buying from RHDJapan usually ends up in the final total of your basket being about double what you thought it would be, after all the bullshit fees and such are added on.
×
×
  • Create New...