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

    • 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.
    • GTSBoy
      Ethanol Content Sensor - Always at 11%?

      By GTSBoy · Posted

      The hydrocarbon component of E10 can be shittier, and is in fact, shittier, than that used in normal 91RON fuel. That's because the octane boost provided by the ethanol allows them to use stuff that doesn't make the grade without the help. The 1c/L saving typically available on E10 is going to be massively overridden by the increased consumption caused by the ethanol and the crappier HC (ie the HCs will be less dense, meaning that there will definitely be less energy per unit volume than for more dense HCs). That is one of the reasons why P98 will return better fuel consumption than 91 does, even with the ignition timing completely fixed. There is more energy per unit volume because the HCs used in 98 are higher density than in the lawnmower fuel.
    • GTSBoy
      Blue slip

      By GTSBoy · Posted

      No, I'd suggest that that is the checklist for pneumatic/hydraulic adjustable systems. I would say, based on my years of reading and complying with Australian Standards and similar regulations, that the narrow interpretation of Clause 3.2 b would be the preferred/expected/intended one, by the author, and those using the standard. Wishful thinking need not apply.
    • GTSBoy
      Blue slip

      By GTSBoy · Posted

      Yes they do. For some maybe. But for those used the most by abusers, ie Skylines, the numbers are known. The stock eyebrow height for R32/3 Skylines is about 365/375mm or thereabouts. The minimum such heights are recorded in adjacent columns in the database.
    • soviet_merlin
      Ethanol Content Sensor - Always at 11%?

      By soviet_merlin · Posted

      Hmmm, interesting. Makes me wonder whether there is bias as well. It's the cheapest fuel, so it is used for all kinds of ill-maintained shitboxes which are bound to have issues regardless. Nicer cars tend to require higher octane rated fuel and can't use it anyway. FWIW, the official NSW E10 facts page is decent. 
×
×
  • Create New...