How to Convert Columns of Sheet 1 to Rows of Sheet 2 using Macros

Column 5 sheet2, was meant to be 2,not 1 as you have 5 for name 3?

Thank you for mentioning that.
and now its rectified..

Anyone have any idea on the above :-(
i'm totally confused..
Please help me...

Try this:-
Your Data :- Sheet 1
Results :- Sheet 2.

Please Login or Register  to view this content.

Regards Mick

Thank you Mick.
I'll try this with modification and let you know my result :-)

thank u once again for your time and reply

Thank you mick and
There is one problem.
Your solution is working fine with the sample i've given.
now the problem is this.
I'm having more than 5 rows for "Name 1" but your code is taking the first value and the last value.
Where should i correct the macro.

Hi mick
i've made some changes to the Code but it gives me repeated values on the cells.

Code with changes.

Please Login or Register  to view this content.

Try this:-
The code will display the data for each unique Name in a seperate line.

Please Login or Register  to view this content.

Regards Mick

Thank you Mick it works perfect..... :-)
thank you very much

Your welcome

Mick..
i do have one more doubt..
I want to copy and paste the last two cells of each rows till the longest row ends...

Then this will look like

Column 1 Column 2 Column 3 Column 4 Column 5 Column 6
Name1 A 1 B 2 Yes
Name2 C 3 No
Name3 D 4 E 5 Yes

this

Column 1 Column 2 Column 3 Column 4 Column 5 Column 6
Name1 A 1 B 2 Yes
Name2 C 3 C 3 No
Name3 D 4 E 5 Yes


any idea ???
please help me

What happens when you have say, 6 columns in the first row and 4 in the second leaving 2 blank cells in the row to fill with the previous 4, or some similar scenario, or do you jsut want the last 2 in any row with blanks, to fill the remaining cells.

The second choice Just want to fill the last 2 of each row with blanks, to fill the remain.
but the correspondent rows only . last two of 4th row is copied in 4th row and 5th row is copied in fifth row... hope u got me... :-)
thank you very much for your help... :-)

Try this:-
If not what you want, please post more detailed example.

Please Login or Register  to view this content.

Regards Mick