+ Reply to Thread
Results 1 to 7 of 7

Data arrange

  1. #1
    Registered User
    Join Date
    05-05-2022
    Location
    Mexico
    MS-Off Ver
    Office 365
    Posts
    3

    Data arrange

    Hi guys and thank you for your help in advance.

    So I have this list with 2518 values in column A, it has the name of the company and in the next cell the name of a product, some companies have 1 or more products. I need to put in column B the name of the company, doing one by one is going to take an eternity, is there a way to doit faster?

    I attached some pictures of what i need to do.

    Thank you again!

    Screen Shot 2022-05-05 at 7.31.40 p.m..png

    Screen Shot 2022-05-05 at 7.32.22 p.m..png
    Last edited by interm; 05-06-2022 at 08:24 AM.

  2. #2
    Registered User
    Join Date
    05-05-2022
    Location
    Mexico
    MS-Off Ver
    Office 365
    Posts
    3

    Re: Data arrange

    I just uploaded the file.

    Thanks
    Attached Files Attached Files

  3. #3
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: Data arrange

    Welcome to the Forum interm!

    This will go faster if you provide a sample file instead of a picture. See yellow banner at the top of the page.

    Do all products start with "["? If so here is one idea.



    Values as displayed
    A
    B
    1
    B-S
    B-S
    2
    [083
    B-S
    3
    Bish
    Bish
    4
    [EZO
    Bish
    5
    Black
    Black
    6
    [N10
    Black
    7
    [R10
    Black
    Underlying formulas
    A
    B
    1
    B-S
    =A1
    2
    [083
    =IF(LEFT(A2,1)="[",B1,A2)
    3
    Bish
    =IF(LEFT(A3,1)="[",B2,A3)
    4
    [EZO
    =IF(LEFT(A4,1)="[",B3,A4)
    5
    Black
    =IF(LEFT(A5,1)="[",B4,A5)
    6
    [N10
    =IF(LEFT(A6,1)="[",B5,A6)
    7
    [R10
    =IF(LEFT(A7,1)="[",B6,A7)
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  4. #4
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: Data arrange

    Here is your updated file. The solution is a little more complicated because you are using spaces to force indentation.
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    05-05-2022
    Location
    Mexico
    MS-Off Ver
    Office 365
    Posts
    3

    Re: Data arrange

    That's it!!!! Thank you very very much!!!!

  6. #6
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: Data arrange

    You're welcome and thanks for the rep!

    To mark your thread "solved" go to the menu immediately above your first post to the thread and click on Thread Tools. From the dropdown menu select "Mark this thread as solved..."

  7. #7
    Forum Expert dosydos's Avatar
    Join Date
    12-09-2015
    Location
    Massachusetts
    MS-Off Ver
    365(PC) V:2202
    Posts
    1,468

    Re: Data arrange

    in Cell B1:
    then just drag down. Will work as long as all your products contain " [ "

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    <----- If you are happy with your solution please click on the "* Add Reputation" as a way to say thank you.

+ 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. Replies: 1
    Last Post: 11-25-2021, 12:54 PM
  2. Arrange data
    By Harry1986 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-10-2018, 09:12 AM
  3. Arrange the data
    By drp99246 in forum Excel General
    Replies: 3
    Last Post: 10-28-2017, 03:20 AM
  4. Re-arrange Particular Data
    By meranamjkr in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-12-2014, 01:29 PM
  5. [SOLVED] Arrange data in row
    By mandukes in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-03-2014, 11:38 AM
  6. arrange data
    By cassiopea in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-09-2011, 10:55 AM
  7. Arrange data
    By ordinateur in forum Excel General
    Replies: 7
    Last Post: 02-17-2010, 12:53 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