How about using the following steps? 1.  Create two new datasets from Policy_Fact table by using Querybuilder.  The first dataset will contain two columns, pol_num_txt and Service_Tax.  Assign new column name, Amount, to Service_Tax.  The second dataset will contain two columns, pol_num_txt and Sales_tax.  Assign new column name, Amount, to Sales_tax.  So, you will have two identical datasets which have two columns, pol_num_txt and Amount.  The Amount column on the first dataset actually contains data of Service_Tax, and the Amount column on the second dataset actully contains data of Sales_tax.  See examples below. First Dataset                                                                                    Second Dataset pol_num_txt     Amount                                                                   pol_num_txt         Amount 101                   12                                                                           101                        8    102                   12                                                                           102                        8 103                   12                                                                           103                        8 2.  Open the first dataset and run Append Table.  Append Table is located under Data function.  Append Table enables you to concatenate the first dataset and second dataset.  After completing Append Table, sort the table by pol_num_txt. ... View more

If you are using the summary table task, you can just check the box for "Save results to a dataset" on the Results menu.  Then, run the report.  You should see the html file and also a dataset.  Open the dataset and select Microsoft Excel under the Send To menu. ... View more

Thank you Risa.  It worked perfectly.  After assigning the numbers, I could use the Split function.  Thank you so much! ... View more

Thank you Nick.  I created the computed column, Count1, with the function, monotonic(t1.Name).  The Count1 column assigned sequential numbers, but they were for an entire data set as shown below.  In other words, it didn't start from 1 for Mary Adams.  Name                 Phone                 Count1 John Smith       111-222-3333              1 John Smith       123-525-8888              2 John Smith       222-444-9999              3 Mary Adams     333-888-7777              4 Mary Adams     337-841-1111             5 ... View more

The icon was numeric only.  I'll change the type to numeric and run.  Thank you. ... View more

Thank you Doc.  To use the Rank task, I need to set data type of PhoneNumbers to numeric.  Am I correct? ... View more

Thank you NickT.  Now, I would like to know how I can accomplish this task in Enterprise Guide without writing the code.  Would somebody help me? ... View more

Have you checked Appendix A? It explains the data used in the book. You can create the data sets or download from support.sas.com/authors. ... View more