+ Reply to Thread
Results 1 to 9 of 9

Moving data from one column into two columns based on original data set

  1. 06-03-2020, 04:08 AM #1
    Christopherdj
    Christopherdj is offline
    Forum Contributor
    Join Date
    10-13-2011
    Location
    Australia
    MS-Off Ver
    Office 16
    Posts
    329

    Moving data from one column into two columns based on original data set

    Hi all
    Wondering if someone has time to solve this problem for me.
    I have to categories, CORE and ELECTIVE both showing in Column A.
    Codes appear first, and descriptions appear directly below the code.
    I would like to have it automated to Move the Code into Column C and Description into Column D.
    The words CORE and ELECTIVE do not need to be moved, they can be deleted however the Unit Codes and Descriptions must remain in the same order as per column A. File is attached as an example.
    many thanks in anticipation.
    Attached Files Attached Files
    Last edited by Christopherdj; 06-03-2020 at 06:59 PM.
    Reply With QuoteRegister To Reply
  2. 06-03-2020, 04:37 AM #2
    Eastw00d
    Eastw00d is offline
    Valued Forum Contributor Eastw00d's Avatar
    Join Date
    02-29-2020
    Location
    Breda, NL
    MS-Off Ver
    2016, 2019
    Posts
    833

    Re: Moving data from one column into two columns based on original data set

    Mabye you can copy these formulas down in columns C and D:
    Please Login or Register  to view this content.
    There is no need to do some VBA

    Cheers
    Erwin
    I started learning VBA because I was lazy ...
    Still developing.... being more lazy...
    Reply With QuoteRegister To Reply
  3. 06-03-2020, 06:00 AM #3
    sintek
    sintek is offline
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,284

    Re: Moving data from one column into two columns based on original data set

    If you want VBA...One Option...
    Please Login or Register  to view this content.
    Good Luck
    I don't presume to know what I am doing, however, just like you, I too started somewhere...
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the star to left of post [Add Reputation]
    Also....add a comment if you like!!!!
    And remember...Mark Thread as Solved.
    Excel Forum Rocks!!!
    Reply With QuoteRegister To Reply
  4. 06-03-2020, 06:57 AM #4
    jindon
    jindon is offline
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,575

    Re: Moving data from one column into two columns based on original data set

    If vba
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  5. 06-03-2020, 08:04 AM #5
    sintek
    sintek is offline
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,284

    Re: Moving data from one column into two columns based on original data set

    @ jindon...
    Thanks for the lesson...A compliment by the way...
    After your last criticism, I have decided to make an effort to study YOUR CODE and try an implement it to assist other start up members...

    How would we ever know of other simplistic solutions if it was not for Members such as yourself...This is after all a teaching platform...
    You always maintain that WE copy code...Yes, I am sure that all members at some or other time made use of another members code as not all members studied Excel...
    The code has always been there...Unless One is A Microsoft Developer...
    It is the Coder who manipulates it and uses it as efficiently as possible...And you EXCEL at doing that...

    So thank you for your valuable contribution...
    Reply With QuoteRegister To Reply
  6. 06-03-2020, 08:31 AM #6
    jindon
    jindon is offline
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,575

    Re: Moving data from one column into two columns based on original data set

    Understanding how it works and worked when I changed a bit, but really don't know why, are totally different story.

    I don't post a code as a SOLUTION, when I don't know why it worked and I will be trying to understand the reason why it worked.
    Otherwise I may be end up with confusing people.

    It doesn't matter how much you know about Excel/VBA, don't touch it when you are not certain.

    By the way, you don't need to study my code, there are lots of better codes everywhere.
    Every coder has their own coding style, so don't waste your time studying my codes.
    Reply With QuoteRegister To Reply
  7. 06-03-2020, 02:00 PM #7
    sintek
    sintek is offline
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,284

    Re: Moving data from one column into two columns based on original data set

    so don't waste your time studying my codes.
    As This Forum Has Proven Time & Time Again...Never A Waste...Thanks Again...
    Reply With QuoteRegister To Reply
  8. 06-03-2020, 06:57 PM #8
    Christopherdj
    Christopherdj is offline
    Forum Contributor
    Join Date
    10-13-2011
    Location
    Australia
    MS-Off Ver
    Office 16
    Posts
    329

    Re: Moving data from one column into two columns based on original data set

    Thanks Jindon, this works perfectly.
    I appreciate your work.
    Reply With QuoteRegister To Reply
  9. 06-03-2020, 06:59 PM #9
    Christopherdj
    Christopherdj is offline
    Forum Contributor
    Join Date
    10-13-2011
    Location
    Australia
    MS-Off Ver
    Office 16
    Posts
    329

    Re: Moving data from one column into two columns based on original data set

    I tried this one but it mixed the Core units and descriptions backwards, however the Elective units and descriptions were ok.
    I also tried Jindon's outcome and that worked. So thank you for your attempt, problem is now solved.
    All users on here are extremely helpful. Thanks again - Chris
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Formula that results in data input moving down a column based on another column cell data
    By gammoneer2b in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-22-2020, 04:01 AM
  2. Clean-up of a raw data set, moving data to column based on type and text
    By Graxon in forum Excel General
    Replies: 12
    Last Post: 11-03-2019, 08:28 AM
  3. [SOLVED] Moving data from rows to columns based on data
    By xan175 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 04-03-2018, 02:49 PM
  4. Moving data from a column to rows based on another calls data
    By Emmylou in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-13-2014, 07:42 AM
  5. [SOLVED] Moving Data Down one, Left one based on data in same row, different column
    By carrie.cllek in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-27-2013, 06:03 PM
  6. Moving Data Down one, Left one based on data in same row, different column
    By carrie.cllek in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-27-2013, 05:03 PM
  7. Sorting, finding dulicates, moving one data element up, deleting original data
    By rickwtx in forum Excel Programming / VBA / Macros
    Replies: 22
    Last Post: 01-13-2011, 07:32 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1