abdulbasitb
New Member
- Joined
- Apr 21, 2015
- Messages
- 17
Hi everyone,
Is there a quick way of generating a table or pivot-table showing all possible combinations of prescribed options.
The example file shows what I'm after
INPUT
<tbody>
</tbody>OUTPUT
<tbody>
</tbody>
Is there a quick way of generating a table or pivot-table showing all possible combinations of prescribed options.
The example file shows what I'm after
INPUT
<tbody> </tbody> | |||||||||||||||||||
<tbody>
</tbody>
Furniture | Material | Condition | Finishing color | Cost |
Chair | Wooden | New | White | |
Chair | Wooden | New | Red | |
Chair | Wooden | New | Black | |
Chair | Wooden | Used | White | |
Chair | Wooden | Used | Red | |
Chair | Wooden | Used | Black | |
Chair | Plastic | New | White | |
Chair | Plastic | New | Red | |
Chair | Plastic | New | Black | |
Chair | Plastic | Used | White | |
Chair | Plastic | Used | Red | |
Chair | Plastic | Used | Black | |
Chair | Steel | New | White | |
Chair | Steel | New | Red | |
Chair | Steel | New | Black | |
Chair | Steel | Used | White | |
Chair | Steel | Used | Red | |
Chair | Steel | Used | Black | |
Table | Wooden | New | White | |
Table | Wooden | New | Red | |
Table | Wooden | New | Black | |
Table | Wooden | Used | White | |
Table | Wooden | Used | Red | |
Table | Wooden | Used | Black | |
Table | Plastic | New | White | |
Table | Plastic | New | Red | |
Table | Plastic | New | Black | |
Table | Plastic | Used | White | |
Table | Plastic | Used | Red | |
Table | Plastic | Used | Black | |
Table | Steel | New | White | |
Table | Steel | New | Red | |
Table | Steel | New | Black | |
Table | Steel | Used | White | |
Table | Steel | Used | Red | |
Table | Steel | Used | Black |
<tbody>
</tbody>