Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Transpose | Excel Worksheet Functions | |||
Transpose from Col to row | Excel Worksheet Functions | |||
Transpose a .csv | Excel Programming | |||
Want to Transpose | Excel Discussion (Misc queries) | |||
I WANT TO TRANSPOSE LINKS, AS WE TRANSPOSE VALUES | Excel Worksheet Functions |