Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 12
Default create additional rows containing data from one original row

I have a spreadsheet of informational data containing mostly text that has
for each row one master id number, and then columns containing detail
information. one column for various colors, a second column for various
sizes.

I want to create multiple rows for each combination of master id number,
color, and size.

I figured a pivot table would be the best way to approach this, but I am not
certain where to start.
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
can I create backup file in separate folder from the original? MCC Wong Setting up and Configuration of Excel 9 January 19th 08 02:06 AM
Please respond: Need to create additional measure in pivot table Angel Excel Discussion (Misc queries) 1 June 19th 06 08:19 PM
How can I add additional rows beyond the 65,536 in excel 2003 pbhatt07 Excel Worksheet Functions 6 April 18th 06 11:20 PM
prevent additional rows accesspro Excel Discussion (Misc queries) 2 March 11th 06 03:06 AM
Taking in account additional rows JB12 Excel Discussion (Misc queries) 3 December 27th 05 07:05 PM


All times are GMT +1. The time now is 10:05 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"