Hi guys,

I have got bites of the code working fine already. However cannot figure how to transpose the data in columns in output 1. Hence I need a VBA code which can the following:

have paid 2$ to OZgrid and will pay $20 to the person who completes the task. ETA Friday 26/05/2017 if possible.

I have got bites of the code working fine already. However cannot figure how to transpose the data in columns in output 1. Hence I need a VBA code which can the following:

- Copy BD in column A in “output 1” for all rows
- Column B in "output 1" is counter which will have 1 to 48 for each date
- Copy BC in column C in “output 1” for all rows
- Column D in “Output 1” is row heading from “Raw Data” which needs to be replicated
- Transpose data as below:

- If column BE starts with E, copy C to AX from raw data into column E in “Output 1”
- If column BE starts with Q, copy C to AX from raw data into column F in “output 1”
- If column BE starts with B, copy C to AX from raw data into column G in “output 1”
- If column BE starts with K, copy C to AX from raw data into column H in “output 1”

- Copy formula from I2 to P2 to the last row in “Output 1”
- Refresh the pivot table in column T in “Output 1”

have paid 2$ to OZgrid and will pay $20 to the person who completes the task. ETA Friday 26/05/2017 if possible.