When I import my inventory records from the accounting package this is
what I have:-
Code Size
1 3
1 6
1 7
2 2
2 3
2 4
2 6
3 4
4 1
4 3
You get the picture - twelve pages of codes with different sizes.
This is what I need:-
Code Sizes
1 3 6 7
2 2 3 4 6
3 4
4 1 3
With a random number of lines being reported for the sizes for the
product codes, I can't figure out a way to run a copypaste
specialtranspose macro because doing it manually sucks.
It would be best if the sizes went into different columns so I could
run further analysis but any ideas gratefully accepted.
--
Brisbane Rob
------------------------------------------------------------------------
Brisbane Rob's Profile:
http://www.excelforum.com/member.php...o&userid=25096
View this thread:
http://www.excelforum.com/showthread...hreadid=537553