SOLVED
How to separate data from one column to multiple columns?
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Kshen
7 - Meteor
‎10-07-2021
03:35 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello,
In column E of the table below (see table #1), there are G/L accounts starts from 3xxxxx and 5xxxxx. I'd like to separate 3xxxxx and 5xxxxx into two columns and align with their correspondence Sum_Line Item amount. Table 2 is the result that I am looking for. Can some one please let me know what is the best way of doing this? Much appreciate it!
Table 1
Table 2 (Result)
Solved! Go to Solution.
Labels:
- Labels:
- Best Practices
- Developer Tools
2 REPLIES 2
16 - Nebula
‎10-07-2021
04:46 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎10-07-2021
05:25 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
This works!! Thanks a million!
