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?
Bookmarks