Hello All
I have a massive spreadsheet with lots of clients and all their respective jobs. All their job info are all in the same row but across columns. Please see attachment for example.
This is very messy for us and we want to clean it up however, there are over 1000 clients and each client has multiple jobs for us (between 5-30). There are also more than 5 questions per job, there are about 13 questions per job request.
This is what I want for our spreadsheets:
Insert a row beneath the client ABC because in column K, the value is Yes. Then, take the data in cells L2:Q2 and copy them into the newly inserted row, F3:K3.
2016-04-03_16-52-49.jpg
2016-04-03_16-55-49.jpg
Then again, if Q2's cell = Yes, then insert info from R2:W2 2 rows below. That would be the final product for one client.
2016-04-03_16-57-06.jpg
2016-04-03_16-59-51.jpg
I've attached the spreadsheet with a before tab and an after tab.
Please let me know if this is possible through macro if there are any questions.
Thank you
Bookmarks