Data in column G is list of files with sub directories output of windows command dir /s /b
filed 1 ,field 2 is user name password field 3 is recovery key , column G has folder listings with tree sort of listing for files,folders subdirectories.
An entry in a cell G is something like
│ │ ├───VpnClient
│ │ │ └───en-US
│ │ ├───Wdac
│ │ ├───WindowsDeveloperLicense
│ │ ├───WindowsErrorReporting
│ │ ├───WindowsSearch
│ │ │ └───en
│ │ └───WindowsUpdate
│ ├───Schemas
│ │ └───PSMaml
│ └───SessionConfig
├───winevt
│ ├───Logs
│ └───TraceFormat
├───WinMetadata
├───winrm
│ └───0409
├───zh-CN
└───zh-TW
these are various files and folders in a tree format. These are contents of a cell in column A and B, field 1 and field 2 are username passwords of how they will be accessible.
So an entry in cell G may be a complete excel sheet itself like folder a ,folder b ,folder c , file 1 ,file2 ,file 3
i am not able to understand how to organize all this in a neat and elite way in an excel so that I can search at a later date easily or
the information can be read easily when needed.
I hope this makes it clear if not please let me know. I will explain further.
Bookmarks