How to transpose a 2-column vert range to a new row

[MannStewart]

hi

so i have a small 2-column vertical range from EA2:EB11, which user inputs data into the cool blue filled ranges every day.

After entering these data every time in EA2:EB11, the user needs to click on the macro button to transpose these entire set of data to a consecutive new single row (see fig1).

My code below is not accomplishing this:

Please Login or Register  to view this content.

Done right, the pasted rows should keep expanding downwards (see fig2).



Can anyone kindly offer a code that can do this ?

att: workbook
Stewart

[TMS]

Can't look at it just now, but I think you'd need a loop. For each row, copy the source pairs into the destination array, incrementing the target index by 2 each time through the loop.

So, row 1, entries 1 and 2 go in 1 and 2; row 2, entries 1 and 2 go in 3 and 4; row 3, entries 1 and 2 go in 5 and 6; etc.

[MannStewart]

hi TMS

i'm hoping to avoid a loop method as my PC isn't as fast as it used to be. Isn't there any other ways to change maybe this line ?

Please Login or Register  to view this content.

[sintek]

'm hoping to avoid a loop method as my PC isn't as fast as it used to be

Will take less than a second...Such a small dataset...A cell loop will even work...

Anyway...Here no loop option...

Please Login or Register  to view this content.

[MannStewart]

Thank You very much sintek, your code .. superb, worked perfectly

out of the water lifting an X-wing fighter it is like

cheers
Stewart

[AliGW]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of all those who offered help.

[sintek]

..........................
Thanks.png