Help with transpose?
 

Hello,

I have an Excel spreadsheet with the following columns:

No. Date Model Part#
01 5/1 100 0120 0150 0156 0255 0325 0352
02 5/5 200 0170 1150 0956 0265 1325 2352
03.............

What can I do (maybe macro) to put in another sheet in the following format?
Part# Model No.
0120 100 01
0150 100 01
0156 100 01
0255 100 01
0325 100 01
0352 100 01
0170 200 02
1150 200 02
0956 200 02
0265 200 02
1325 200 02
2352 200 02

Thanks

Help with transpose?
 

Assuming source table as posted in cols A to I,
data from row2 down, with 6 cols of Part#
In K2:
=OFFSET($D$2,INT((ROWS($1:1)-1)/6),MOD(ROWS($1:1)-1,6))
In L2:
=OFFSET($C$2,INT((ROWS($1:1)-1)/6),)
In M2:
=OFFSET($A$2,INT((ROWS($1:1)-1)/6),)
Select K2:M2, copy down until zeros appear, signalling exhaustion of data
extract
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Cam" wrote:
I have an Excel spreadsheet with the following columns:

No. Date Model Part#
01 5/1 100 0120 0150 0156 0255 0325 0352
02 5/5 200 0170 1150 0956 0265 1325 2352
03.............

What can I do (maybe macro) to put in another sheet in the following format?
Part# Model No.
0120 100 01
0150 100 01
0156 100 01
0255 100 01
0325 100 01
0352 100 01
0170 200 02
1150 200 02
0956 200 02
0265 200 02
1325 200 02
2352 200 02

Thanks