Hello,
I have a macro enabled attachment.
In this attachment is a script which transpose multiple rows and 1 column to multiple columns and 'two rows'. If you run the macro, you'll see the name is a row above the rest, but it should be the same row.
What should i change in the script? It is probably quite easy.
I made an sheet 'How it should be'. It contains how it should be transposed.
Maybe:
Please Login or Register to view this content.
Last edited by JOHN H. DAVIS; 08-26-2014 at 08:44 AM.
Maybe:
Please Login or Register to view this content.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Getting hung up on trying to use arrays for everything. So, instead, maybe this:
Please Login or Register to view this content.
Regards, TMS
Hi,
Here's another proposal :
Please Login or Register to view this content.
GC Excel
If this post helps, then click the star icon (*) in the bottom left-hand corner of my post to Add reputation.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks