Hi,
I have data that looks like this:
Cust no. cust name item Jun Jul Aug
1 a x 1 2 3
2 b y 2 3 4
3 c z 3 4 5
But I need it to look like this:
Cust no. cust name item peroid Data
1 a x Jun 1
2 b y Jul 2
3 c z Aug 3
1 a x Jun 2
2 b y Jul 3
3 c z Aug 4
1 a x Jun 3
2 b y Jul 4
3 c z Aug 5
since the original data is from ODBC, it would be nice that it can be done on a separate worksheet. The usual transpose method does not work well for this project.
Help please. thanks.
I have data that looks like this:
Cust no. cust name item Jun Jul Aug
1 a x 1 2 3
2 b y 2 3 4
3 c z 3 4 5
But I need it to look like this:
Cust no. cust name item peroid Data
1 a x Jun 1
2 b y Jul 2
3 c z Aug 3
1 a x Jun 2
2 b y Jul 3
3 c z Aug 4
1 a x Jun 3
2 b y Jul 4
3 c z Aug 5
since the original data is from ODBC, it would be nice that it can be done on a separate worksheet. The usual transpose method does not work well for this project.
Help please. thanks.