Avatar of jskfan
jskfan
Flag 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
Scripting LanguagesMicrosoft ExcelMicrosoft Office

Avatar of undefined
Last Comment
jskfan

8/22/2022 - Mon
SOLUTION
Máté Farkas

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
ASKER CERTIFIED SOLUTION
aikimark

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
SOLUTION
David L. Hansen

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
jskfan

ASKER
Thank you
Your help has saved me hundreds of hours of internet surfing.
fblack61