trmacdonal
New member
- Local time
- Today, 17:08
- Joined
- Oct 1, 2009
- Messages
- 3
Hello,
I have been trying to solve this issue for a while and think there must be a simple way to do it. I have 16 columns in a table. The first is an Item code, then after that is Size_01 - Size_15. Currently each item appears once and there is an quantity amount in each of the size columns. Is there a simple way to make the table that looks like this:
Item Code Size QTY
AAAA Size_01 6
AAAA Size_02 3
...
AAAA Size_15 4
If anyone has done this before I would be very interested to know how you did it.
Thanks,
Trevor
I have been trying to solve this issue for a while and think there must be a simple way to do it. I have 16 columns in a table. The first is an Item code, then after that is Size_01 - Size_15. Currently each item appears once and there is an quantity amount in each of the size columns. Is there a simple way to make the table that looks like this:
Item Code Size QTY
AAAA Size_01 6
AAAA Size_02 3
...
AAAA Size_15 4
If anyone has done this before I would be very interested to know how you did it.
Thanks,
Trevor