Filtering a CSV with Active Directory Users and Groups

Hello,

This is probably trivial for most people here, but I have a csv file from a script that reads out AD Users and their associated groups. The problem is that it spits it out in one long string in the first cell.
Every line is a new user and it's hundreds of users, so not done manually. I've made a sample file that has the same structure. I want to be able to search for a group and see which users are associated with it. I've already wrote a Python script that reads it out and removes all the spaces en qoutation marks, but I've been stuck since then.

Can someone here help me with this? Many thanks.

SampleData.csv

I'm seeing your data in separate rows with the fields combined in column A.

If that is typical, you can use Text to Columns with comma and double quote as the delimiters. See the updated sample file (saved as .xlsx)

As you are using 365, you can use functions like UNIQUE and FILTER amongst others to present the data.

Old school, you could perhaps use a Pivot Table.

Please provide a more realistic and representative file to work with.

Are there any headings for this data?

Not sure what you want to enter, where you want to enter it, and what you expect to see.

Hi,
It can be done with Power Query. Go to Data tab, Get & Transform group and choose "From text/CSV" option.
Select your CSV file and click Open.
In yhe new opened window select comma as a delimiter and than click Transform. The Power Query editor will be open. In PQ editor click split column, select "by delimiter" and choose comma as a delimiter. This will split your table in two columns.
Select the second column, click split column, select "by delimiter", expand the Advanced and choose "by row".
Right click on each table column and rename as you wish.
After that you can choose from Close& Load menu the option "Close&Load To" and choose table. After loading you can filter the group as you wish.

I have been playing with this, on and off, for a few days. To be fair, mostly for my own education

The attached workbook has grown, to some extent, and now has several sheets.

Stage 0 - Instructions. Self explanatory
Stage 1 - Where you input and split the raw data
Stage 2 - Don't touch. It is automatic
Stage 3 - Ditto
Stage 4 - Is where you can select a group and list its users
Stage 5 - A backup copy of the original test data

Hope this works for you. Please don't ask how (some of) the formulae work