Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Page 1 of 2 12 LastLast
Results 1 to 10 of 11

Thread: reformat spreadsheet

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    8
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi Experts,
    I got some problem. I have a spreadsheet in this format:
    A1 A2 A3 A4
    1 A Pte Ltd SAM Siemens Intel
    2 B Pte Ltd
    3 C Pte Ltd Mot Hitachi AMD
    and the list goes on.

    There are some rows with A1 data but A2 onwards are blank. That means, Company with carrying no brand names (eg. B Pte Ltd).

    How do I reformat the list to be as below and omit those with no brand names :

    A1 A2 A3 A4
    1 A Pte Ltd SAM
    2 A Pte Ltd Siemens
    3 A Pte Ltd Intel
    4 C Pte Ltd Mot
    5 C Pte Ltd Hitachi
    6 C Pte Ltd AMD


    Thanks!

  2. #2
    Board Regular
    Join Date
    Mar 2002
    Location
    Sydney/Brisbane , Australia
    Posts
    542
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    why dont you run an auto filter on column 2.
    and then filter for "BLANK"
    and delete the lines it then shows?

  3. #3
    New Member
    Join Date
    Apr 2002
    Posts
    8
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Ok but I need to format the data to appear downwards also.

  4. #4
    Board Regular
    Join Date
    Mar 2002
    Location
    Sydney/Brisbane , Australia
    Posts
    542
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    so is a4 currently Sam Siemens Intel?
    or is a4=sam,a5=Siemans,a6 = intel?

  5. #5
    New Member
    Join Date
    Apr 2002
    Posts
    8
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    A1= A Pte Ltd ,A2= SAM, A3= Siemens, A4= Intel

    to be :
    A1: A Pte Ltd
    A2: Sam
    B1: A Pte Ltd
    B2: Siemens
    C1: A Pte Ltd
    C2: Intel

    Sounds tedious.

  6. #6
    Board Regular
    Join Date
    Mar 2002
    Location
    Sydney/Brisbane , Australia
    Posts
    542
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    EVERY1 FEEL FREE TO ASSIST

    i am trying to work on a code to
    a: count the number of brands in a row
    b: copy the brands in the row
    c: insert that number of rows(=to number of brands)
    d: transpose the brands...
    e:goto next line

  7. #7
    New Member
    Join Date
    Apr 2002
    Posts
    8
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Number of brands is not fixed for any company. So company A can have 3 , while Company F could have only one. I can't say there is any max number of brands for each company. Range from 0 to x.


  8. #8
    Board Regular
    Join Date
    Feb 2002
    Location
    Huntington Beach, CA USA
    Posts
    327
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi goofydisney,
    I see your new to this board, hang in there even though a lot of people will jump in w/ the right intentions to help, it's easy to get very,very frustrated. I posted a simple
    formula question last nite and was told to "slow down" , "check my calcs" and they even
    were joking amongst each other on my thread
    even though they couldn't figure out the formula. Then along came the "master" of formulas Aladin, I hope he sees your post.
    Good Luck

    James

  9. #9
    New Member
    Join Date
    Apr 2002
    Posts
    8
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi James,
    Thanks You guys on this board are so helpful. I am from Singapore and yesterday was a holiday (MayDay) and I can't believe it you guys are helping out here.

    In Singapore, we say "Give that guy a Tiger Beer!"

  10. #10
    New Member
    Join Date
    Apr 2002
    Posts
    8
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi Experts,
    I hope you can help me on this one.

    Rdgs

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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