Loading
Ozgrid Excel Help & Best Practices Forums

Excel Training / Excel Dashboards Reports



Results 1 to 2 of 2

Thread: VBA unstructured data into structured please help

  1. #1
    Join Date
    14th June 2013
    Posts
    6

    VBA unstructured data into structured please help

    The data actually shows the timings of various movie shows from a particular theatre multiplex

    scroll down to see the actual unstructured data and the structured format i am aiming for.

    v A
    2 Unstructured data in vertical format
    3
    4 Multiplex: Forum, Bengaluru
    5 Doctor Strange (UA)
    6 English, 3D
    7 0.395833
    8 Befikre (UA)
    9 Hindi, 2D
    10 0.409722
    11 0.4375
    12 0.5625
    13 0.652778
    14 0.791667
    15 0.916667
    16 Dhruva (UA)
    17 Telugu, 2D
    18 0.409722
    19 0.510417
    20 0.649306
    21 0.774306
    22 0.916667
    23 Moana (U)
    24 English, 3D
    25 0.409722
    26 0.510417
    27 0.715278
    28 0.815972
    29 Ekkadiki Pothavu Chinnavada (UA)
    30 Telugu, 2D
    31 0.416667
    32 Kahaani 2 (UA)
    33 Hindi, 2D
    34 0.416667
    35 0.53125
    36 0.666667
    37 0.791667
    38 0.913194
    39 Dear Zindagi (UA)
    40 Hindi, 2D
    41 0.430556
    42 0.534722
    43 0.784722
    44 0.909722
    45 Underworld: Blood Wars (A)
    46 English, 3D
    47 0.482639
    48 John Jani Janardhan (UA)
    49 Kannada, 2D
    50 0.534722
    51 0.791667
    52 Chennai 600028 Second Innings (U)
    53 Tamil, 2D
    54 0.559028
    55 0.913194
    56 Office Christmas Party (A)
    57 English, 2D
    58 0.611111
    59 0.916667
    60 Santhu Straight Forward (U)
    61 Kannada, 2D
    62 0.65625
    63 Dieyana House (UA)
    64 Kannada, 2D
    65 0.6875
    66 Deepwater Horizon (UA)
    67 English, 2D
    68 0.6875
    69 Hands Of Stone (UA)
    70 English, 2D
    71 0.694444
    72 0.916667
    73 Mummy (A)
    74 Kannada, 2D
    75 0.798611
    76 Saithan (UA)
    77 Tamil, 2D
    78 0.802083
    79 Arrival (UA)
    80 English, 2D
    81 0.916667

    v C D E F G
    2 The way it should be
    3
    4 Multiplex Name Movie Name Movie Type Timing 1 Timing 2
    5 Multiplex: Forum, Bengaluru Doctor Strange (UA) English, 3D 9.30 AM
    6 Multiplex: Forum, Bengaluru Befikre (UA) Hindi, 2D 9.50 AM 10.30 AM
    7 Multiplex: Forum, Bengaluru Dhruva (UA) Telugu, 2D 9.50 AM 12.15 PM
    8 Multiplex: Forum, Bengaluru Moana (U) English, 3D 9.50 AM 12.15 PM
    9 Multiplex: Forum, Bengaluru Ekkadiki Pothavu Chinnavada (UA) Telugu, 2D 10.00 AM
    10 Multiplex: Forum, Bengaluru Kahaani 2 (UA) Hindi, 2D 10.00 AM 12.45 PM
    11 Multiplex: Forum, Bengaluru Dear Zindagi (UA) Hindi, 2D 10.20 AM 12.50 PM
    12 Multiplex: Forum, Bengaluru Underworld: Blood Wars (A) English, 3D 11.35 AM
    13 Multiplex: Forum, Bengaluru John Jani Janardhan (UA) Kannada, 2D 12.50 PM 7.00 PM
    14 Multiplex: Forum, Bengaluru Chennai 600028 Second Innings (U) Tamil, 2D 1.25 PM 9.55 PM
    15 Multiplex: Forum, Bengaluru Office Christmas Party (A) English, 2D 2.40 PM 10.00 PM
    16 Multiplex: Forum, Bengaluru Santhu Straight Forward (U) Kannada, 2D 3.45 PM
    17 Multiplex: Forum, Bengaluru Dieyana House (UA) Kannada, 2D 4.30 PM
    18 Multiplex: Forum, Bengaluru Deepwater Horizon (UA) English, 2D 4.30 PM
    19 Multiplex: Forum, Bengaluru Hands Of Stone (UA) English, 2D 4.40 PM 10.00 PM
    20 Multiplex: Forum, Bengaluru Mummy (A) Kannada, 2D 7.10 PM
    21 Multiplex: Forum, Bengaluru Saithan (UA) Tamil, 2D 7.15 PM
    22 Multiplex: Forum, Bengaluru Arrival (UA) English, 2D 10.00 PM
    23
    Last edited by pike; December 11th, 2016 at 17:28. Reason: covert to table

  2. #2
    Join Date
    10th January 2007
    Location
    Borneo
    Posts
    3,182

    Re: VBA unstructured data into structured please help

    Not sure what you have posted here.

    You have posted in the HIRE HELP forum, you need to state the amount you are offering for a solution in the thread title and pay 10% of that amount to Ozgrid ( [email protected] ) before posting.

    Attach a sample workbook that clearly shows current structure and desired structure.

    How to Attach a Sample Workbook

    To attach a workbook:

    1. Click 'Go Advanced' at the bottom right of the Reply Box.
    2. In the new window click the Paper Clip Icon.
    3. In the new window that pops up click 'Add Files'.
    4. Click 'Select File' and browse to the required file.
    5. Click 'Upload File'.
    6. Click 'Done' when the selected file appears in the box at the bottom of the window.

    The maximum file size allowed is 3MB, if your file is larger than this you can try zipping it to reduce the size. If still too large, or if your actual file contains sensitive data, then create a sample workbook with reduced amount of data or with sanitised data.

    When creating a sample workbook it is essential that the structure of the actual workbook is retained.
    • If data has been sanitised, then the sanitised data must be of the same type as the original (text still text, numbers still numbers, dates still dates etc.).
    • The Layout of data on each sheet remains the same.
    • If actual data contains blank rows, columns or cells then include the same in the sample data.
    • If a cell contains a formula keep the formula in the sample, in other words do not create the sample file by pasting just values from the actual file.

    An accurate sample workbook will help us to help you.

    We now have a reputation system in place. It can be found on the 'Star' icon on the bottom left hand side of the post

Thread Information

Users Browsing this Thread

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

Possible Answers

  1. Structured Tables and Worksheet Protection
    By sdman2006 in forum Excel General
    Replies: 4
    Last Post: February 6th, 2015, 03:11
  2. Structured Programming Best Practices
    By mikerickson in forum Excel General
    Replies: 5
    Last Post: July 17th, 2007, 16:56
  3. Extract Data From Non-structured Text File
    By ykcin in forum Excel General
    Replies: 15
    Last Post: September 26th, 2006, 19:03
  4. Structured IF statement
    By mattoneill in forum Excel General
    Replies: 2
    Last Post: May 9th, 2005, 18:58
  5. VBA : Working with excel structured file
    By Simonaln in forum Excel General
    Replies: 2
    Last Post: December 26th, 2003, 15:01

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
  •  
porno