Help required to extract data from rows to column in Excel2013

[joy_joy111]

Help required to extract data from rows to column in Excel2013


Afternoon All,
Second post and a request for help straight away. Hopefully,this ok to post.




Disclaimer – Although I’ve used Excel for years for various reasons, I’ll admit my knowledge of how it works is basic to say the least. I have a few issues that I need help to fix, so I may end up creating separate posts.Anyway, here is a start.


My situation is that I have all data in column 1 of excel. I need to extract this data and place it in an excel spreadsheet. To date there are approx 1000+ rows thatI need to work through. In simpler words -
Extract/Scrape data from multiple rows of Excel (xlsx) sheet 1 into specific distributed column in excel sheet 2 (xlsx).




From Googling, I think, I can see that this is possible by using VBA and macro. I’ve tried working through forum posts and youtubetutorials and to my shame haven’t really been able to extract any data. There could be many reasons for this or it could be that I am such a muppet that the problems is with me. This is why I’ve decided to admit my shortcomings and ask for help. No doubt, even with you good People helping, I’ll get it wrong and have to ask some idiot questions.




I’ve attached a copy of the sheet raw data and processed (expected data sample).
Hopefully, this will helpbut if there’s anything else you or I need, let me know.
So, any help appreciated. I am really hoping that I can learn how to do this as I think we’ll be needing to do more of the same with other information.






Sample in attachment may give more idea.

111Excel REq.jpg
I think Logic of code should be


1) Target sheet to have feilds
STUDENT Subject1 Subject2 Subject3 Subject4 MOST LIKED SUBJECT Explanation
2) write a loop to iterate the rows in sheet1(raw data).
3) For StudentX, copy all next rows till studentX again found in sheet1 and paste in result_sheet - Column wise
STUDENT Subject1 Subject2 Subject3 Subject4 MOST LIKED SUBJECT Explanation
4) Start a new row in sheet2(result_sheet) each time "STUDENT X"
5) repeat loop




Is above correct






Many thanks
Joy