Excel: dupplicate rows based on data in a column.


I have a spreadsheet of 18 columns and 1800 rows. I deed to duplicate all columns of a given row based on the data in a specific (Tickets)column. Any help is appreciated. Similar to AK216 January 2013 My example A B C D E F G H I J K etc. Tickets Name Date Item Qty 1 Joe 12/22/2013 Soup 24 3 Sue 12/29/2013 Shrimp 12 2 Jack 02/11/2014 Beans 36 Desired Result 1 Joe 12/22/2013 Soup 24 3 Sue 12/29/2013 Shrimp 12 3 Sue 12/29/2013 Shrimp 12 all columns to be duplicated 3 Sue 12/29/2013 Shrimp 12 2 Jack 02/11/2014 Beans 36 2 Jack 02/11/2014 Beans 36


This question generated 22 answers. To proceed to the answers, click here.

This thread is current as of March 02, 2014.


For more resources for Microsoft Excel