+ Reply to Thread
Results 1 to 11 of 11

Text to columns, transpose data & final result

  1. #1
    Registered User
    Join Date
    08-04-2015
    Location
    India
    MS-Off Ver
    Excel 2016
    Posts
    82

    Text to columns, transpose data & final result

    H Guys,

    I need a macro for attached sheet ...i have separated sheets step by step...

    "Rawdata sheet" - i always gets data in this form
    "1st Step Sheet "- Then i have to do Text to columns
    "2nd Step Sheet "- Then Copy and transpose data
    "Final Result sheet "- This is my required solutions.

    I need all this into 1 button and also pls let me know how to add macro in my personal workbook in which i will paste my rawdata and will press button & desired output appears...
    Attached Files Attached Files
    You can add reputation(s) of those who helped

  2. #2
    Forum Expert MickG's Avatar
    Join Date
    11-23-2007
    Location
    Banbury,Oxfordshire
    Posts
    2,650

    Re: Text to columns, transpose data & final result

    Try this:- From sheet "Raw Data" To Sheets "Final Results "
    Please Login or Register  to view this content.
    Regards Mick

  3. #3
    Registered User
    Join Date
    08-04-2015
    Location
    India
    MS-Off Ver
    Excel 2016
    Posts
    82

    Re: Text to columns, transpose data & final result

    HI MickG,

    I really dnt know where and how to copy paste this codes & also the Rows & columns ranges will be different from this Test file....
    But in the above attachment i have made sheet only for explanation purpose...but i actually needed my data as "final result sheet".

    Note - I get file like Raw data sheet and nothing else

    And can u pls explain me wht do u mean by "Try this:- From sheet "Raw Data" To Sheets "Final Results ".

    I m really noob in Macro thing...

  4. #4
    Forum Expert MickG's Avatar
    Join Date
    11-23-2007
    Location
    Banbury,Oxfordshire
    Posts
    2,650

    Re: Text to columns, transpose data & final result

    Try the code in sheet "Final Result" in the Attached file.
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    08-04-2015
    Location
    India
    MS-Off Ver
    Excel 2016
    Posts
    82

    Re: Text to columns, transpose data & final result

    Test_Rerturned(1) Test.xlsmHI MickG,

    Sorry for the late reply was not in office ....please find the attached sheet.. a little thing is missing ...which i have mentioned in final sheet with examples..

    See if u can solve it ...it will be great help...

  6. #6
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,464

    Re: Text to columns, transpose data & final result

    This should do
    Please Login or Register  to view this content.

  7. #7
    Registered User
    Join Date
    08-04-2015
    Location
    India
    MS-Off Ver
    Excel 2016
    Posts
    82

    Re: Text to columns, transpose data & final result

    Hi Jindon...

    Its not working..please see the attached file above in Final sheet" need results like that

  8. #8
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,464

    Re: Text to columns, transpose data & final result


  9. #9
    Registered User
    Join Date
    08-04-2015
    Location
    India
    MS-Off Ver
    Excel 2016
    Posts
    82

    Re: Text to columns, transpose data & final result

    Hi Jindon.

    Thanks a ton...It works great.. .. 1 Question can i delete 1st & 2nd step sheet from the workbook... i mean can i only keep Rawdata sheet and Final sheet...

  10. #10
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,464

    Re: Text to columns, transpose data & final result

    Just delete unwanted worksheets, it's yours, not mine.

  11. #11
    Registered User
    Join Date
    08-04-2015
    Location
    India
    MS-Off Ver
    Excel 2016
    Posts
    82

    Re: Text to columns, transpose data & final result

    ok...Thanks for your help....

+ 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: 8
    Last Post: 02-03-2015, 03:42 PM
  2. removing data from a table and getting a final result
    By Jimbras in forum Excel General
    Replies: 1
    Last Post: 11-26-2014, 09:10 AM
  3. [SOLVED] Using Text to Columns combined with Transpose in a macro
    By Bax in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 07-01-2013, 04:12 AM
  4. [SOLVED] Macro with text to columns, insert rows, and paste special>transpose
    By diaphanous1138 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 05-22-2013, 02:49 PM
  5. MAcro to - copy, transpose, text to columns, remove column A, combine all columns in 1
    By galvinpaddy in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 02-07-2013, 08:48 AM
  6. [SOLVED] query for work help! showing final result
    By fdabb in forum Excel General
    Replies: 5
    Last Post: 01-26-2006, 06:45 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