In my work, I need transpose the data from one excel sheet,using MACRO ,but the sheet have many different subforms. The orignal data is like this: ID Name W5 W6 W7 W8 W9 W10 W11 1001 A1 12 14 11 11 11 12 13 1002 A2 13 14 12 12 12 13 14                   ID Name Y1 Y2 Y3 Y4 Y5 Y6 Y7 2001 B1 15 16 15 15 15 16 17                   ID Name M3 M4 M5 M6 M7 M8 M9 3001 C1 11 12 13 14 15 16 17   and I need the results like this:   ID Name Time Count 1001 A1 W9 11 1001 A1 W10 12 1001 A1 W11 13 1002 A2 W5 13 1002 A2 W9 12 1002 A2 W10 13 1002 A2 W11 14 2001 B1 Y6 16 2001 B1 Y7 17 3001 C1 M7 15 3001 C1 M8 16 3001 C1 M9 17   Cound someone help me? Thanks. ... View more