taylor58285
New Member
- Joined
- Mar 1, 2014
- Messages
- 14
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
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