+ Reply to Thread
Results 1 to 4 of 4

How to convert rows of data collapsible like with Access

  1. #1
    Forum Contributor
    Join Date
    10-23-2004
    Location
    Los Angeles
    MS-Off Ver
    2010
    Posts
    253

    How to convert rows of data collapsible like with Access

    I know with Access, the raw data looks like Excel, a spreadsheet of data.
    However, I have seen it where in the first cell of the column, there is a "+" sign to the left, where if i click on it, it expands the row and adds a SUB row. How can i do this in Excel?

    I have text data where it's presented in a specified format each sub section of the row.

    Example:

    OH-123E POLE-DISXXXXX
    |-- 201156299 04/12/2010 12/31/9999
    | |--- 201156299 POLE-DISTRIBUTION 123E
    |-- 207008846 10/01/2015 12/31/9999
    |--- 207008846 SWITCH PS0733
    OH-133E POLE-DISXXXXX
    |-- 206981976 07/27/2015 12/31/9999
    |--- 206981976 POLE-DISTRIBUTION 133E
    OH-137E POLE-DISXXXXX
    |-- 201835324 04/13/2010 12/31/9999
    |--- 201835324 POLE-DISTRIBUTION 137E
    OH-138E POLE-DISXXXXX
    |-- 201176079 04/12/2010 12/31/9999
    |--- 201176079 POLE-DISTRIBUTION 138E

    With the excel conversion, this data should be 4 rows "OH-**", and to the left of the row a + sign present where if i click it, i'll see the information below the "OH-***".

    Is this possible to do with Excel?

  2. #2
    Forum Expert BMV's Avatar
    Join Date
    01-13-2020
    Location
    St-Petersburg, Russia
    MS-Off Ver
    2013-2016
    Posts
    1,329

    Re: How to convert rows of data collapsible like with Access

    May be simple grouping can help you.
    Attached Files Attached Files

  3. #3
    Forum Contributor
    Join Date
    10-23-2004
    Location
    Los Angeles
    MS-Off Ver
    2010
    Posts
    253

    Re: How to convert rows of data collapsible like with Access

    Yes! This is what I am looking for... How did you do this? I actually have about 116 rows of these rows that begin with this "OH-***E" (note, it's actually longer than this, but I only put this as an example), but i only put a few as an example. Is there a batch operation to do this?

  4. #4
    Forum Expert BMV's Avatar
    Join Date
    01-13-2020
    Location
    St-Petersburg, Russia
    MS-Off Ver
    2013-2016
    Posts
    1,329

    Re: How to convert rows of data collapsible like with Access

    I showed only example how it could looks like. The grouping is standard method from data menu but it could be done only manually and it is long procedure in you case. It could be done by macro code also.
    Another way is to prepare table and use Pivot table.
    Attached Files Attached Files

+ 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. Convert .txt to Excel or Access table friendly data
    By Juolupuki in forum Access Tables & Databases
    Replies: 10
    Last Post: 03-27-2018, 08:43 AM
  2. Convert .txt to Excel or Access table friendly data
    By Juolupuki in forum Excel General
    Replies: 0
    Last Post: 03-26-2018, 05:52 AM
  3. [SOLVED] Convert multiple rows of horizontal data into three rows of vertical data
    By msutton in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-10-2015, 03:27 AM
  4. Convert an Excel Spreadsheet with Attendance Data to Access Database
    By pradeepp in forum Access Tables & Databases
    Replies: 2
    Last Post: 12-07-2012, 04:23 AM
  5. Replies: 6
    Last Post: 08-18-2012, 05:00 AM
  6. How to Convert Access 1.x to access 2003 or 2010
    By jambai in forum Access Programming / VBA / Macros
    Replies: 1
    Last Post: 03-02-2011, 07:02 PM
  7. [SOLVED] Convert MS Excel data to MS Access database
    By HelpJim in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-02-2006, 11:55 AM

Tags for this Thread

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