How to convert column data to row and column

Hi

The core data worksheet has the following format:

(A) Match number (B) Team A (C) A Score (D) A result (E) Team B (F) B Score (G) B result (H) Year

For example,

(A1) 1 (B1) Team A (C1) 87 (D1) Win with Blue color (E1) Team B (F1) 77 (G1) Loss with Green color (H1) 2007
(A2) 1 (B2) Team C (C2) 76 (D2) Loss with Green color (E2) Team D (F2) 79 (G2) Win with Blue color (H2) 2007

(A3) 2 (B3) Team A (C3) 92 (D3) Win with Blue color (E3) Team D (F3) 88 (G3) Loss with Green color (H3) 2007
(A4) 2 (B4) Team C (C4) 70 (D4) Equal with white color (E4) Team B (F4) 70 (G4) Equal with white color (H4) 2007

(D) and (G) color index are based on the comparsion of (C) and (F)

Now, I need to build a worksheet to show:

(A1) Empty (B1) 1 (C1) 2 (D1) Total Win (E1) Total Loss (F1) Total Equal
(A2) Team A (B2) Win with Blue color (C2) Win with Blue color (D2) 2 (100%) (E2) 0 (F2) 0
(A3) Team B (B3) Loss with Green color (C3) Equal with white color (D3) 0 (E3) 1 (50%) (F3) 1 (50%)
(A4) Team C (B4) Loss with Green color (C4) Equal with white color (D4) 0 (E4) 1 (50%) (F4) 1 (50%)
(A5) Team D (B5) Win with Blue color (C5) Loss with Green color (D5) 1 (50%) (E5) 1 (50%) (F5) 0

How should I code that format of worksheet?
Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories