Link to home
Create AccountLog in
Avatar of jskfan
jskfanFlag for Cyprus

asked on

Excel Filtering in Columns and ROws.

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
SOLUTION
Avatar of Máté Farkas
Máté Farkas
Flag of Hungary image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
ASKER CERTIFIED SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of jskfan

ASKER

Thank you