LinkBack URL
About LinkBacks
I want to transpose numbers in columns to rows but in groups of five numbers.
I need a two solution by:
- Using Excel formulas (if possible)
- Using VBA macro
please You see attach
Thanks advance
I want to transpose numbers in columns to rows but in groups of five numbers.
I need a two solution by:
- Using Excel formulas (if possible)
- Using VBA macro
please You see attach
Thanks advance
Last edited by Dumy; 02-24-2013 at 08:49 AM.
See the attached file how it's possible.
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.
See the attached for a non-volatile formula solution.
B2 can be shortened to this, if you only drag Across to Column F
Formula:
Please Login or Register to view this content.
If you need any more information, please feel free to ask.
However,If this takes care of your needs, please select Thread Tools from menu above and set this topic to SOLVED. It helps everybody! ....
Also
اس کی مدد کرتا ہے اگر
شکریہ کہنے کے لئے سٹار کلک کریں
If you are satisfied by any members response to your problem please consider using the small Star icon bottom left of their post to show your appreciation.
That's it, solution using Excel formulas
Thanks guys
If you want macro as an option
Great, thanks AB33
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks