+ Reply to Thread
Results 1 to 10 of 10

Transpose And Split values from one cell to two from horizontal to vertical

  1. 10-03-2018, 12:26 PM #1
    salmasaied
    salmasaied is offline
    Forum Contributor
    Join Date
    10-23-2015
    Location
    egypt
    MS-Off Ver
    2010
    Posts
    246

    Transpose And Split values from one cell to two from horizontal to vertical

    peace to everyone
    I have received a lot of help from the experts of this forum.So I thank everyone for providing assistance
    To explain what I'm trying to get it to do:
    I have a range ("A5:M5") which I want to convert it from horizontal to vertical
    the objective is
    Transpose And Split values from one cell to two from horizontal to vertical
    I use this line to do this
    Please Login or Register  to view this content.
    How Can I Modify or change the programing Instructions in this line to achieve this objective.
    Thank you very much for all of you
    Last edited by salmasaied; 10-03-2018 at 02:59 PM.
    Reply With QuoteRegister To Reply
  2. 10-03-2018, 12:47 PM #2
    6StringJazzer
    6StringJazzer is offline
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: Transpose And Split values from one cell to two from horizontal to vertical

    What do you mean by "Split values from one cell to two"? What is in the cells now? What do you want them to look like after they are split?
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]
    Reply With QuoteRegister To Reply
  3. 10-03-2018, 01:38 PM #3
    salmasaied
    salmasaied is offline
    Forum Contributor
    Join Date
    10-23-2015
    Location
    egypt
    MS-Off Ver
    2010
    Posts
    246

    Re: Transpose And Split values from one cell to two from horizontal to vertical

    Thanks a lot for your reply
    Assume that you have a value 1245.01 and you want to divide it into two cells.The first cell contains the dollars and the other contains the cents
    I want them to seem so after their split
    Just for clarification ... Please see the attachment file.
    Thank you very much for all of you
    Attached Files Attached Files
    Last edited by salmasaied; 10-03-2018 at 03:18 PM.
    Reply With QuoteRegister To Reply
  4. 10-03-2018, 04:32 PM #4
    salmasaied
    salmasaied is offline
    Forum Contributor
    Join Date
    10-23-2015
    Location
    egypt
    MS-Off Ver
    2010
    Posts
    246

    Re: Transpose And Split values from one cell to two from horizontal to vertical

    All help is much appreciated.
    Reply With QuoteRegister To Reply
  5. 10-03-2018, 05:07 PM #5
    alansidman
    alansidman is offline
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,888

    Re: Transpose And Split values from one cell to two from horizontal to vertical

    No VBA required. In B10 =Int(G7)
    In A10 =G7-Int(G7)
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
    Reply With QuoteRegister To Reply
  6. 10-03-2018, 05:24 PM #6
    salmasaied
    salmasaied is offline
    Forum Contributor
    Join Date
    10-23-2015
    Location
    egypt
    MS-Off Ver
    2010
    Posts
    246

    Re: Transpose And Split values from one cell to two from horizontal to vertical

    I don't think so,I am sure that this is possible, but I cannot find how to do this.
    Reply With QuoteRegister To Reply
  7. 10-03-2018, 10:24 PM #7
    alansidman
    alansidman is offline
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,888

    Re: Transpose And Split values from one cell to two from horizontal to vertical

    I have no idea what your last post means. I have elaborated my response and created a short VBA solution for you that does what I suggested you do with formulae.

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  8. 10-04-2018, 09:27 AM #8
    salmasaied
    salmasaied is offline
    Forum Contributor
    Join Date
    10-23-2015
    Location
    egypt
    MS-Off Ver
    2010
    Posts
    246

    Re: Transpose And Split values from one cell to two from horizontal to vertical

    Thanks a lot for your reply
    In fact the issue is part of large code
    I am just looking to see if this could be change or modified to achieve what I want
    Again, thanks for your kind help
    Reply With QuoteRegister To Reply
  9. 10-04-2018, 10:09 AM #9
    alansidman
    alansidman is offline
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,888

    Re: Transpose And Split values from one cell to two from horizontal to vertical

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
    Reply With QuoteRegister To Reply
  10. 10-04-2018, 06:12 PM #10
    salmasaied
    salmasaied is offline
    Forum Contributor
    Join Date
    10-23-2015
    Location
    egypt
    MS-Off Ver
    2010
    Posts
    246

    Re: Transpose And Split values from one cell to two from horizontal to vertical

    Thanks a lot for your reply
    not yet finished
    Unfortunately not allowed to publish any original files across the Web.So please accept my apologies
    However, I will try to explain my problem in another way ..A new topic will be posted,Thanks again.
    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. Transpose vertical data to horizontal
    By PeterKeown in forum Excel General
    Replies: 6
    Last Post: 08-03-2018, 05:51 AM
  2. Transpose Horizontal to Vertical with multiple key columns
    By deuteron in forum Excel General
    Replies: 3
    Last Post: 04-27-2015, 05:26 PM
  3. Transpose calculated value from horizontal to vertical?
    By max3732 in forum Excel General
    Replies: 4
    Last Post: 09-04-2013, 12:42 PM
  4. Transpose Vertical Data to Horizontal
    By Randu555 in forum Excel General
    Replies: 5
    Last Post: 04-18-2013, 05:05 PM
  5. [SOLVED] Need help transpose Texts and Numbers from Horizontal to vertical to the last Row
    By tuongtu3 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-07-2013, 01:51 PM
  6. [SOLVED] Transpose Horizontal to Vertical with ID Column
    By galaxycoff in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-04-2012, 10:16 PM
  7. [SOLVED] convert vertical to horizontal (without Transpose)
    By timtim89 in forum Excel General
    Replies: 6
    Last Post: 03-28-2012, 10:50 AM

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