+ Reply to Thread
Results 1 to 7 of 7

Transform Column to several columns depending on condition.

  1. 10-14-2013, 04:47 AM #1
    dimitrov_dimityr is offline
    Registered User
    Join Date
    10-12-2013
    Location
    Sofia, Bulgaria
    MS-Off Ver
    Excel 2007
    Posts
    5

    Transform Column to several columns depending on condition.

    Greetings,

    I would like to ask if anyone had met such export and managed to achieve proper transformation.
    Basicly i have in Col A several criteria which i need to separate in columns without losing the infos and numbers which are related to them.

    (like in column M to P)
    The number will be different depending on the extraction i get for different requests.

    Thanks for your time
    BR
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 10-14-2013, 07:01 AM #2
    sktneer is offline
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,655

    Re: Transform Column to several columns depending on condition.

    Very confusing. What you are trying to do? Please explain in the sheet itself.
    Regards
    sktneer

    Treat people the way you want to be treated. Talk to people the way you want to be talked to.
    Respect is earned NOT given.
    Reply With QuoteRegister To Reply
  3. 10-14-2013, 07:31 AM #3
    dimitrov_dimityr is offline
    Registered User
    Join Date
    10-12-2013
    Location
    Sofia, Bulgaria
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: Transform Column to several columns depending on condition.

    Here. Hope this is clearer
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  4. 10-14-2013, 07:36 AM #4
    OllieB is offline
    Forum Expert OllieB's Avatar
    Join Date
    12-20-2012
    Location
    Netherlands
    MS-Off Ver
    Excel 2007 (home) & 2010 (office)
    Posts
    1,542

    Re: Transform Column to several columns depending on condition.

    dimitrov,

    so column A is provided and the number of spaces in front of the text determines the nesting level. For example 0 spaces is level 1 (should be written in column M), 3 spaces is level 2 (should be written to column N, and so forth?
    If you like my contribution click the star icon!
    Reply With QuoteRegister To Reply
  5. 10-14-2013, 07:41 AM #5
    nilem is offline
    Forum Expert nilem's Avatar
    Join Date
    10-22-2011
    Location
    Ufa, Russia
    MS-Off Ver
    2013
    Posts
    3,377

    Re: Transform Column to several columns depending on condition.

    Hi Dimityr,
    try it
    Please Login or Register  to view this content.
    option
    Please Login or Register  to view this content.
    Last edited by nilem; 10-14-2013 at 07:56 AM. Reason: add option
    Reply With QuoteRegister To Reply
  6. 10-14-2013, 07:45 AM #6
    OllieB is offline
    Forum Expert OllieB's Avatar
    Join Date
    12-20-2012
    Location
    Netherlands
    MS-Off Ver
    Excel 2007 (home) & 2010 (office)
    Posts
    1,542

    Re: Transform Column to several columns depending on condition.

    or (only outputting rows when a value for column P is found)

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  7. 10-14-2013, 08:11 AM #7
    dimitrov_dimityr is offline
    Registered User
    Join Date
    10-12-2013
    Location
    Sofia, Bulgaria
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: Transform Column to several columns depending on condition.

    Came up with a form with text boxes to input the number of spaces before each level of the export and rearange the column with these values. 10 was the biggest number of different spaces. 

    Please Login or Register  to view this content.
    I will try with the sub you gave me.
    Any suggestions how to reduce the code? Couse i am just beggining to do such stuff and it probably looks terrible

    Damn it took me a lot of time to get this post....

    THANKS for the reply. It does work great.
    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. select only certain columns depending upon last row in column A
    By mickjjuk in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-22-2013, 11:42 AM
  2. Copy formulas in 4 columns down depending of last use cell in another column.
    By Fotis1991 in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 12-18-2012, 01:07 PM
  3. MACRO to transform single column to multiple columns, based in dynamic values
    By gaqueiroz in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-08-2012, 01:54 PM
  4. Sum values in column, depending on two different columns value
    By avelinov in forum Excel General
    Replies: 1
    Last Post: 02-16-2012, 09:18 AM
  5. summe column depending of other columns
    By jokenjo in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 05-15-2007, 06:13 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