Most valuable professional
  • Hot Topics

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 2, 2014.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel