create additional rows containing data from one original row

J

jwbuyer

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Create a chart from a table in word thats dynamic 0
Adding a big matrix in Word 2013 5
Formula's won't read copy / pasted data ? 2
PivotTable - Filter Row 0
Copy data from unlocked cells 3
Split report for email 5
Macro to copy rows into worksheets 4
Combining data from multiple rows 2

Top