mrice
Forum Guru

Dear Mrice are you there?

Apologies, yes that did work

Thank you again, your service has been extremely helpful!

It should already cope with this, have you tried it?

mrice, you are very helpful and for that I thank you; however not to keep bothering you about this topic, is it possible to expand on this i.e. if there are multiple IDs:


if....
ID.....Region 1.....Region 2.....Region 3.....Channel 1.....Channel 2
1...........X...........................................X.....................X......................X
2..................................X....................X.....................X

then...
ID Region Channel
1 Region 1 Channel 1
1 Region 1 Channel 2
1 Region 3 Channel 1
1 Region 3 Channel 2
2 Region 2 Channel 1
2 Region 3 Channel 1


And so on if additional IDs are added

Will post example to Forum

Thank you for the response

http://www.excelforum.com/excel-prog...ml#post2436458

However I am having difficulty executing the macro, could you please help?

I have the initial table beginning in cell a1 (entire table: 2r x 6c)

Thank you,

John

Nvm, I messed around a bit with it and figured it out. Thanks again a ton though, this macro is kicking *** on this project.

Hey you helped me out with some recent code to fill a master sheet with info from various other sheets.

For N = 2 To SourceWorkSheet.Cells(SourceWorkSheet.Rows.Count, 1).End(xlUp).Row
For M = 3 To Cells(Rows.Count, 1).End(xlUp).Row
If Cells(M, 1) = SourceWorkSheet.Cells(N, 1) And Cells(M, 2) = Condition Then
SourceWorkSheet.Range(SourceWorkSheet.Cells(N, 3), SourceWorkSheet.Cells(N, 12)).Copy Destination:=Cells(M, 4)
End If
Next M
Next N
End Sub

Anyway I'm doing the same thing but with a slightly different layout now for a different set of data on the same project. I'm assuming I could restructure this macro slightly and make it work for my new task as well. Do you think you could explain the logic to me for what is happening in the portion I posted above? If i can better understand it I'm sure I could restructure this macro for my current task and the future ones I have with this project.

Sir,

I have a excel file containing data records continuously in rows. I would like to convert it into columns.

Col A Col B
Row 1 ID 30159
Row 2 Name Bala
Row 3 Design TO
Row 4 Respon Emails
Row 5 Fax
Row 6 Computer
Row 7 HRD
Row 8 JDate 20/04/2010
Row 9 <Blank>
Row 10 ID 30160
Row 11 Name Balamurugan
Row 12 Design SO
Row 13 Respon Shorthand
Row 14 Data Entry
Row 15 JDate 20/04/2010
Row 16 <Blank>
Row 17 [Next record]...

As you can see from the data above, the data in the field 'Respon" is not of fixed size. It may increase of decrease (in terms of rows). Also after a blank row the next record starts therefore there should be a line break after every blank row.

Could you please help me by the way of a macro to solve the above?
Thanks a lot!
Bala

Helped me with a complex excel issue. Created a perfect soloution extemely rapidly. As a new member to the forums I found his help most beneficial. Thank you.