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.

sorry I want Row wise

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.

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

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

Dear Marcol


pls check the attached file.

pls help me

Regards,
Nandkumar S.

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........