troubleshooting Question

Excel Filtering in Columns and ROws.

Avatar of jskfan
jskfanFlag for Cyprus asked on
Scripting LanguagesMicrosoft ExcelMicrosoft Office
4 Comments3 Solutions284 ViewsLast Modified:
Excel Filtering in Columns and ROws.

I have the attached text File. I would like to use it in Excel and want to know if there is  away on how to filter on Columns and Rows ?
for instance I need to get all the Policy names that are scheduled for "Tuesday" as shown under "Daily Windows: Or all Policy names that have "Policy Type" as MS-Windows (13).

I am not sure if I can just leave the file in text file, and if any Expert can come up with a script that gives me options to select which data to Search for, and based on that data I put in it will generate an Excel file.

Well, any idea that helps is very welcomed.

Thank you
FilterPolicies.txt
ASKER CERTIFIED SOLUTION
aikimark
Get vaccinated; Social distance; Wear a mask
Join our community to see this answer!
Unlock 3 Answers and 4 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 3 Answers and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros