Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- JMP User Community
- :
- Discussions
- :
- How to transform one character column with row lev...

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Feb 8, 2017 9:07 AM
(1071 views)

2 ACCEPTED SOLUTIONS

Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Feb 8, 2017 9:20 AM
(2117 views)

Solution

You can use column formulas. They will either copy a new level from the left in the current row or a repeating value from above the previous row. You can use the amount of white space (indentation) to determine which column should use the value. You will have some missing values for the intial rows and below where the previous column resets

Learn it once, use it forever!

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Feb 8, 2017 9:40 AM
(2114 views)

Solution

I attached a data table to show the approach I described at work. It doesn't handle special cases yet.

Learn it once, use it forever!

5 REPLIES

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Feb 8, 2017 9:20 AM
(2118 views)

You can use column formulas. They will either copy a new level from the left in the current row or a repeating value from above the previous row. You can use the amount of white space (indentation) to determine which column should use the value. You will have some missing values for the intial rows and below where the previous column resets

Learn it once, use it forever!

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Feb 8, 2017 9:31 AM
(1063 views)

So you are wanting it to look like this?

If so, I created the columns as formulas and used the Item function to pull the proper pieces out of the Location column.

Dan Obermiller

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Feb 8, 2017 10:03 AM
(1054 views)

However, is there a way to fill the columns for each row? Some Row subscript?

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Feb 8, 2017 9:40 AM
(2115 views)

I attached a data table to show the approach I described at work. It doesn't handle special cases yet.

Learn it once, use it forever!

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Feb 8, 2017 10:07 AM
(1053 views)