+ Reply to Thread
Results 1 to 4 of 4

formatting data in column g

Hybrid View

  1. #1
    Registered User
    Join Date
    10-10-2020
    Location
    Pune
    MS-Off Ver
    2019
    Posts
    10

    formatting data in column g

    Here is my excel.
    data in column A ,column G all is linked.
    The problem is data in column G is not very neatly organized.
    I am wondering is there a better way to organize these entries in excel.
    I do not know how to handle several entries that should fit in one cell.
    That is a part of a row. The entries in cell are too complex to fit in small excell.
    Attached Files Attached Files

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 insider Version 2504 Win 11
    Posts
    24,717

    Re: formatting data in column g

    Not enough information to offer any help. It would be helpful if you told us specifically what you would like to happen in column G. Maybe show us a mocked up version of your solution. We are experts at Excel but complete failures at mind reading. My crystal ball fell off the table this morning and shattered. Help us to help you by telling exactly what you need.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Registered User
    Join Date
    10-10-2020
    Location
    Pune
    MS-Off Ver
    2019
    Posts
    10

    Re: formatting data in column g

    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.

  4. #4
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 insider Version 2504 Win 11
    Posts
    24,717

    Re: formatting data in column g

    Did you miss this request in my post?
    Maybe show us a mocked up version of your solution.
    What do you want the output to look like?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 4
    Last Post: 10-10-2019, 02:55 PM
  2. Pivot Data Column formatting
    By ExcelDumb-e in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 10-30-2012, 10:32 AM
  3. Conditional formatting - Column of data
    By PFDave in forum Excel General
    Replies: 7
    Last Post: 07-27-2012, 08:04 AM
  4. Formatting raw data for column chart
    By radicaled in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 06-24-2012, 08:59 PM
  5. Data Formatting from Row to Column
    By vipulpatel3681 in forum Excel General
    Replies: 4
    Last Post: 11-22-2011, 08:50 AM
  6. Replies: 5
    Last Post: 10-26-2011, 11:57 AM
  7. Replies: 2
    Last Post: 07-29-2010, 09:57 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1