- Each week I export a xlsx file from an external source and can't change how the data is exported/received. It usually will have hundreds, maybe even a few thousand rows.
- There are 17 columns, one for each of the 12 months, another 4 representing each of the four quarters and 1 more representing the total for the year.
- Starting with column A, each row is populated with various values, let's say A2 is populated with Channel 4. In this case E2 would be populated with $5000 because $5000 is the value for January.
- Because Channel 4 also had revenue in Feb, A3 is populated with Channel 4 and F3 has a value of $4500 for Feb.
- Channel 4 also had revenue in March so A4 is populated with Channel 4 and G4 has the value of $6000 for March.
- This continues throughout the year, with a new row being added for each month.
I'm on a new work computer and don't have admin rights to upload the Excel Add In that would enable me to "upload image" so I could share a sample. I'm working on getting that resolved, but thought I'd try with the explanation above.
Thanks in advance