LinkBack URL
About LinkBacks
Hello,
I am looking for a help in either vba or excel formulas to convert a set of categorized data vertically to horizontal by category.
Appreciate the support.
attached photo for an example:
Capture.PNG
Hello,
I am looking for a help in either vba or excel formulas to convert a set of categorized data vertically to horizontal by category.
Appreciate the support.
attached photo for an example:
Capture.PNG
Last edited by whallak; 02-16-2019 at 12:47 PM.
Try this code
Similar issue at this link
Please Login or Register to view this content.
https://www.excelforum.com/excel-pro...sheet-2-a.html
< ----- Please click the little star * next to add reputation if my post helps you
Visit Forum : From Here
This macro assumes that your headers are in row 1 and the data starts in row 2. The result will be placed in Sheet2.
Please Login or Register to view this content.
You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
Practice makes perfect. I'm very far from perfect so I'm still practising.
Thank you Yasser, this was very helpful.
I noticed that once the data are plotted on Column E, they are plotted by order of existence as available in range B.
Would it be possible to have them plotted by alphabetical order ?
Instead of having A,C,B,D,E
to have A,B,C,D,E, etc...
check the attached photoCapture.PNG
Can you attach a sample workbook so as to be easier to work on?
Try
Please Login or Register to view this content.
here is the workbook
Thank you
Get the Power Query add-in - it will be simple then.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Please Login or Register to view this content.
Last edited by jindon; 02-18-2019 at 05:48 AM.
Hello Jindon,
It is still not plotting them by alphabetical order. And it would be better to plot the data on the same sheet cell(1,8).
attached workbook if needed.
Originally Posted by jindon
Please Login or Register to view this content.
Alphabetical order?
Please Login or Register to view this content.
yes if you check the below photo, the plotting in the new sheet starts with the first category, and not by alphabetical order (a,b,c,d,...)
check the photo:
Capture.PNG
Alphabetical order?
Please Login or Register to view this content.
1)
Don't quote whole posts -- it's just clutter.
If you are responding to a post out of sequence, limit quoted content to a few relevant lines that makes clear to whom and what you are responding
For normal conversational replies, try using the QUICK REPLY box below.
2) Which one are you talking about?
Wonderful,
Thank you for the support, and also for the guidance. That is my second day here, good to know such guidelines.
Regards,
You are welcome and thanks for the rep.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks