Dear all, after long day , once again , need macro to data transpose from horizontal input to vertical output.
before data
after data
Please Login or Register to view this content.
Please check the attachment for better understanding.Please Login or Register to view this content.
Last edited by nur2544; 09-22-2013 at 11:14 AM.
Try the macro below.
Please Login or Register to view this content.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Hi oeldere, thanks for replay, It is not working for me , please check the attachment, here I have mention that Column A is my input data. And from this input I need output as like row J2 to O2 .
Hi oeldere, I am extremely sorry for my great mistake in the thread problem title, I was not aware at all, how ever your macro was correct as per my previous asking which was “Data transpose (from horizontal input to vertical output)”. Instead of “Data transpose (from horizontal input to vertical output)” , the problem title will be Data transpose (from vertical input to Horizontal output)”. Sorry once again for wasting your valuable time.
Last edited by nur2544; 09-22-2013 at 11:15 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks