Forum Discussion
Help Me with How to Keep Inside +/- Box Data in Table format
- Anonymous2 years ago
Hi Anonymous ,
Here are the steps you can follow:
1. Select [Date] – Split Column -- Split Column by Delimiter.
Select or enter delimiter -- Custom “|”.
Split at – Each occurrence of the delimiter.
2. Perform the following operations on [Date.2], [Date.3], and [Date.4]:
Split Column -- Split Column by Delimiter.
Select or enter delimiter – Colon
Split at – Left – most delimiter.
3. Select [Date2.1], [Date3.1], [Date4.1] – Remove Column.
4. Modification of column names
5. Row headers – turn off -- +/- icons and Stepped layout.
6. Turn off – Column subtotals and Row subtotals.
7. Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi Anonymous ,
Here are the steps you can follow:
1. Select [Date] – Split Column -- Split Column by Delimiter.
Select or enter delimiter -- Custom “|”.
Split at – Each occurrence of the delimiter.
2. Perform the following operations on [Date.2], [Date.3], and [Date.4]:
Split Column -- Split Column by Delimiter.
Select or enter delimiter – Colon
Split at – Left – most delimiter.
3. Select [Date2.1], [Date3.1], [Date4.1] – Remove Column.
4. Modification of column names
5. Row headers – turn off -- +/- icons and Stepped layout.
6. Turn off – Column subtotals and Row subtotals.
7. Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly