+ Reply to Thread
Results 1 to 4 of 4

Help! Data Clean Up!

  1. #1
    Registered User
    Join Date
    08-24-2010
    Location
    Manila
    MS-Off Ver
    Excel 2003
    Posts
    6

    Help! Data Clean Up!

    Good Day Everyone!

    I need your expert help on how to re-arrange data

    I want to make a good statistical analysis of the attached file but I want to do it in a fast manner without doing too much clerical. Hopefully the output will be a nice pivot table that I can graph depending on the total number of people per flag registry, per vessel type, per vessel type of a specific flag registry.

    Thanks.

    Dino
    Data.xlsx

  2. #2
    Forum Expert RobertMika's Avatar
    Join Date
    06-22-2009
    Location
    Haverhill, UK
    MS-Off Ver
    Excel 2003-13
    Posts
    1,530

    Re: Help! Data Clean Up!

    This is alredy copy of PT.
    Do you have raw data?
    If you are http://www.excelforum.com/image.php?type=sigpic&userid=125481&dateline=1392355029happy with the results, please add to the contributor's
    reputation by clicking the reputation icon (star icon).




    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved.
    To undo, select Thread Tools-> Mark thread as Unsolved.
    http://www.excelaris.co.uk

  3. #3
    Registered User
    Join Date
    08-24-2010
    Location
    Manila
    MS-Off Ver
    Excel 2003
    Posts
    6

    Re: Help! Data Clean Up!

    Hi Robert. That is the raw data given to me.

  4. #4
    Forum Expert RobertMika's Avatar
    Join Date
    06-22-2009
    Location
    Haverhill, UK
    MS-Off Ver
    Excel 2003-13
    Posts
    1,530

    Re: Help! Data Clean Up!

    This is copy of PT.You should ask for data in table format or you will have quite lot to do on your report

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Coding Convention Questions #2 (To clean up or not to clean up)
    By mc84excel in forum Excel Programming / VBA / Macros
    Replies: 24
    Last Post: 03-31-2014, 08:18 PM
  2. [SOLVED] VBA Code to optimize and clean data- clean out numerical/ or symbol
    By tracylsr in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-05-2012, 04:21 PM
  3. Clean Function to Clean Entire Sheet
    By gema in forum Excel General
    Replies: 7
    Last Post: 11-05-2009, 10:07 AM
  4. Data Clean Up
    By dowd79 in forum Excel General
    Replies: 1
    Last Post: 01-18-2007, 05:33 AM
  5. Clean Up Data
    By ultra_xcyter in forum Excel General
    Replies: 2
    Last Post: 08-11-2006, 03:50 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1