1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Solved: Probably a very simple excel question...

Discussion in 'Business Applications' started by eVILRigby, Feb 18, 2012.

Thread Status:
Not open for further replies.
Advertisement
  1. eVILRigby

    eVILRigby Thread Starter

    Joined:
    Nov 25, 2003
    Messages:
    110
    Hello,
    many thanks in advance for taking the time to have a look and any help any can offer. Basically I am trying in an excel spreadsheet to get from...

    Code:
    Section
    Heaven Sword & Dragon Sabre
    9781588991836
    9781588991850
    9781588991867
    9781588991874
    9781588992413
    9781588992420
    9781588992437
    9781588992444
    Section
    Hellgirl
    9780345497475
    9780345504166
    9780345504173
    9780345504180
    9780345506696
    9780345508454
    9780345512208
    Section
    etcetera...
    
    to

    Code:
    Section
    Heaven Sword & Dragon Sabre
    Heaven Sword & Dragon Sabre
    Heaven Sword & Dragon Sabre
    Heaven Sword & Dragon Sabre
    Heaven Sword & Dragon Sabre
    Heaven Sword & Dragon Sabre
    Heaven Sword & Dragon Sabre
    Heaven Sword & Dragon Sabre
    Heaven Sword & Dragon Sabre
    Section
    Hellgirl
    Hellgirl
    Hellgirl
    Hellgirl
    Hellgirl
    Hellgirl
    Hellgirl
    Hellgirl
    Section
    etcetera...
    
    I suspect this is probably not a massively difficult thing to do, but sadly it does fall just beyond the scope of my immediate excel knowledge (and what I can usually puzzle out myself from a quick bit of rooting around on the internet).

    Basically I'm trying to manipulate my ecommerce data for import into something else which requires me to have an extra category variable per product. I have obviously copied the current column in my spreadsheet to retain the current information, this is an extra requirement.

    It is always laid out in the Section, then the variable name I want to replace the 13 digit codes below, before you come to the next Section. Can anyone suggest a way to automate this please? I have about a 20,000 line spreadsheet so I don't really want to do it by hand if possible!

    Many thanks as always for any help and suggestions.

    kind regards,
    Jonathan
     
  2. bomb #21

    bomb #21

    Joined:
    Jul 1, 2005
    Messages:
    8,545
    If the values are in column A, you could use:

    =IF(A2="Section","Section",IF(ISTEXT(A2),A2,B1))

    in B2, then copy it down. And then copy > paste special (values) the results. Five minutes by hand, prolly.

    (B1 = "Section" to start off)
     
  3. eVILRigby

    eVILRigby Thread Starter

    Joined:
    Nov 25, 2003
    Messages:
    110
    That's great thank you. Only tripped up on the odd record where there is no barcode and I used text as the product reference, but they were easy to spot and sort with a quick cut and paste. Many thanks, you saved me a lot of time.
    kind regards,
    Jonathan
     
  4. bomb #21

    bomb #21

    Joined:
    Jul 1, 2005
    Messages:
    8,545
    Thanks for marking this Solved.
     
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/1041594

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice