First time using this site, and I think I have a headache of a challenge.
I regularly receive a spreadsheet from another company listing services as shown in the attachment. This list can sometimes be thousands of rows with data like is shown. However, I need to have all the services showing in one column. I need to find the easiest possible way to have it recognize when there is an X in column's E through L, place them in a single column with one service per row. When this is done, the related information must also be added with it. In the attachment, I included a second page with how I am hoping to be able to have the information reorganized. What is highlighted on the second tab is what I need, while what is in red is information that can be deleted once the translation is made.
This information is going to be on a new spreadsheet from the one that I receive.
Thank you very much for any help that you can provide.
My skill level with Excel is ok.
I just recently taught myself Index-Match, but do not know macros yet.
I have played around with the transpose formula, but it does not seem to be capable of doing what I need to do.
I currently have Excel 2013.
I regularly receive a spreadsheet from another company listing services as shown in the attachment. This list can sometimes be thousands of rows with data like is shown. However, I need to have all the services showing in one column. I need to find the easiest possible way to have it recognize when there is an X in column's E through L, place them in a single column with one service per row. When this is done, the related information must also be added with it. In the attachment, I included a second page with how I am hoping to be able to have the information reorganized. What is highlighted on the second tab is what I need, while what is in red is information that can be deleted once the translation is made.
This information is going to be on a new spreadsheet from the one that I receive.
Thank you very much for any help that you can provide.
My skill level with Excel is ok.
I just recently taught myself Index-Match, but do not know macros yet.
I have played around with the transpose formula, but it does not seem to be capable of doing what I need to do.
I currently have Excel 2013.