+ Reply to Thread
Results 1 to 9 of 9

Arrange the raw data to coloumwise.

  1. #1
    Forum Contributor satputenandkumar0's Avatar
    Join Date
    11-08-2012
    Location
    Pune, India
    MS-Off Ver
    Office xp & Office 2007
    Posts
    398

    Lightbulb Arrange the raw data to coloumwise.

    Hi forum,

    I have the lot off raw data in my excel sheet.(I have attached sample) that data I have to arrange in below format.

    Name Gender / Age Education Education Details ................
    Drupad Mallena M/22 sters in Science Master of Science (Information Technology ) ........................

    pls see my attachment.

    hop you will solve my problem.

    thanks
    Nandkumar S.
    Attached Files Attached Files

  2. #2
    Forum Contributor satputenandkumar0's Avatar
    Join Date
    11-08-2012
    Location
    Pune, India
    MS-Off Ver
    Office xp & Office 2007
    Posts
    398

    Re: Arrange the raw data to coloumwise.

    sorry I want Row wise

  3. #3
    Forum Guru (RIP) Marcol's Avatar
    Join Date
    12-23-2009
    Location
    Fife, Scotland
    MS-Off Ver
    Excel '97 & 2003/7
    Posts
    7,218

    Re: Arrange the raw data to coloumwise.

    Does this workbook do as you need? The result is in Sheet2.

    Check out the Names Manager.

    Why all the merged cells? They cause nothing but grief.
    Attached Files Attached Files
    If you need any more information, please feel free to ask.

    However,If this takes care of your needs, please select Thread Tools from menu above and set this topic to SOLVED. It helps everybody! ....

    Also
    اس کی مدد کرتا ہے اگر
    شکریہ کہنے کے لئے سٹار کلک کریں
    If you are satisfied by any members response to your problem please consider using the small Star icon bottom left of their post to show your appreciation.

  4. #4
    Forum Contributor satputenandkumar0's Avatar
    Join Date
    11-08-2012
    Location
    Pune, India
    MS-Off Ver
    Office xp & Office 2007
    Posts
    398

    Re: Arrange the raw data to coloumwise.

    Dear Marcol,

    firstly thanks for your great solution,
    sir, I have unmerged sheet1 please give me the formula for all field.
    Its very urget.. pls sir help me
    (pls find attached file)

    Hop you will do for me.

    Thanks ,
    Nandkumar S.
    Attached Files Attached Files

  5. #5
    Forum Guru (RIP) Marcol's Avatar
    Join Date
    12-23-2009
    Location
    Fife, Scotland
    MS-Off Ver
    Excel '97 & 2003/7
    Posts
    7,218

    Re: Arrange the raw data to coloumwise.

    Please check your attachment, I can't get it to download.

  6. #6
    Registered User
    Join Date
    11-28-2012
    Location
    of phcali
    MS-Off Ver
    Excel 2010
    Posts
    6

    Re: Arrange the raw data to coloumwise.

    I really don't know how helpful this is because I can't download your file, but this is one that I used to convert a table into a column. Once it is converted into a column, you can transpose the data into a row.

    If you have a lot of raw data, just put in the parameters and replace "a" and "b" in line 4 of the macro with whatever rows you are working with. You will also need to change the Resize function (lines 5 and 6) to match your columns (I just put in (1,x), but you could put in (5,8) if your columns go from 5-8).

    Sub jtest()
    Dim xRow As Long, xData As Variant
    With Worksheets("Sheet1")
    For xRow = a to To b
    xData = .Range("B" & xRow).Resize(1, x).Value
    Worksheets("Sheet2").Cells(Rows.Count, "A").End(xlUp).Offset(1, 0).Resize(x, 1) = Application.WorksheetFunction.Transpose(xData)
    Next
    End With
    End Sub

  7. #7
    Forum Contributor satputenandkumar0's Avatar
    Join Date
    11-08-2012
    Location
    Pune, India
    MS-Off Ver
    Office xp & Office 2007
    Posts
    398

    Re: Arrange the raw data to coloumwise.

    Dear Marcol


    pls check the attached file.

    pls help me

    Regards,
    Nandkumar S.
    Attached Files Attached Files

  8. #8
    Forum Guru (RIP) Marcol's Avatar
    Join Date
    12-23-2009
    Location
    Fife, Scotland
    MS-Off Ver
    Excel '97 & 2003/7
    Posts
    7,218

    Re: Arrange the raw data to coloumwise.

    I have tidied up Form 1 on Sheet1 and used this as the controlling template for the other "Forms"

    It is essential that the headers in Sheet2 Row 1 match these exactly, no leading ,trailing, or extra spaces.
    The changes are highlighted with red text.

    The Form numbers in Sheet1 Column A must be numbers, not numbers stored as text.
    If they are text the formulae used will skip that form.

    So in Sheet2 A2, Drag/Fill Down until blanks are returned.
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    In B2, Drag Across to Column AE then Drag Down.
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    In AF2, Drag Across to Column AH then Drag Down.
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    See the Names Manager for the Dynamic Named Range definitions, don't be tempted to change these to refer to whole Columns, you'll cripple the sheet, the ranges will automatically adjust to suit your datas' exact size.

    In this sample workbook I have only filled the first ten forms,to complete select A2:AH2 and Drag/Fill down some 300 rows, get out a few bottles of "Kalyani Black Label" and sit back, it will take a while to crunch through the data ...

    If you have similar large problems in the future, you might be best to use the new pay forum, I doubt if many members will be willing to do this size of problem for free. ...
    Attached Files Attached Files

  9. #9
    Forum Contributor satputenandkumar0's Avatar
    Join Date
    11-08-2012
    Location
    Pune, India
    MS-Off Ver
    Office xp & Office 2007
    Posts
    398

    Re: Arrange the raw data to coloumwise.

    Thank you Marcol,

    Hat's of you........
    Thank you very much it work perfect.....
    You are great.................

    pls give me contact id

    $$$$$satpute$$$$$nandkumar0$$$$@$$$gmail.com
    remove $ sign

    pls........

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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