I think I am learning but I’m stumped a little on this one…. I have one data source that spits out a CSV of contents in groups and files. It’s a metadata dump from Devonthink. Incredibly useful, but would be more useful if there was an easy way to make Excel see groups.
The data looks like this:
1: Name, Type, meta1, meta 2, etc…
2: “My Fancy Group Name”, Group, x, y, …
3: “FancyPDF.PDF”, PDF Document, z, d, …
4: “Notes.txt”, Document, x, y…
5: “Another Group Name”, Group, d, f, …
6: “Big_text)_doc.rtf”, document, h, I, ….
7: “Last Group Name”, Group, r, 45, …
8: “text file.txt”, document, 32, 45, ….
9: “report.pdf”, PDF Document, 6, g, …
10: “file.doc”, Document, 9, 12, ….
The structure is that one row reports the Folder name, and give a type of “Group”…. The following rows are contents in the folder until a row contains the type “Group” again… and it repeats on and on, in my case for 680 unique groups for which I could make some nice graphs and charts in Excel with the meta data reported in the later columns.
Maybe Excel is smart enough to do this on its own and I’m not smart enough to tell it how, So I’ve in the past kludged what I needed to get “Group By” in Excel. In order to have Excel see groups, I’ve managed in the past to copy the group name from rows like 1, 5, and 7 to the subsequent rows of each in a new first column. Then, I can tell Excel to “Group By” column A, etc…
Is there a method in EDT that can make the input data above into this?
1: Group_Name, Name, Type, meta1, meta 2, etc…
2: “My Fancy Group Name”,“My Fancy Group Name”, Group, x, y, …
3: “My Fancy Group Name”,“FancyPDF.PDF”, PDF Document, z, d, …
4: “My Fancy Group Name”,“Notes.txt”, Document, x, y…
5: “Another Group Name”, Group, d, f, …
6: “Another Group Name”,“Big_text)_doc.rtf”, document, h, I, ….
7: “Last Group Name”, “Last Group Name”, Group, r, 45, …
8: “Last Group Name”, “text file.txt”, document, 32, 45, ….
9: “Last Group Name”, “report.pdf”, PDF Document, 6, g, …
10: “Last Group Name”,“file.doc”, Document, 9, 12, ….
