Hi all,
I am trying to load in some excel data and apply the correct section value to the section name.
The data looks like the following..
| Section | 201901 | 201902 |
| Item | | |
| Manufacturing PV | 11,210 | 10,310 |
| Freight PV | 110 | 91 |
| Duty PV | 2,810 | 910 |
| Export Sales | (8) | (3,398) |
| Retail Sales | (23,012) | (21,102) |
| Trade Sales | (23,080) | (2,210) |
| Sales Admin | (930) | (3,180) |
| Marketing | (2,110) | (22,192) |
| QC | (11,093) | (12,918) |
| | | |
| | | |
| | | |
| Distribution | | |
| Salaries | (3,031) | (8,039) |
| Travel | -- | -- |
| Sundry | (28) | (22) |
The 'Section' field contains a combination of 'section names' and 'section values', so Item is a name and the values that i need to appear against it would be 'Manufacturing PV', 'Freight PV' etc, then Distribution is a name and the values would be 'Salaries', 'Travel' etc.
The names are determined by looking at the first column after it and checking if there is a value, if there is not (its blank) then the value in the Section field is a section name.
I have done this logic and extracted all of the Section Names into it's own field, but i also need to ensure that the Section Values are linked to the name, this is what i am struggling to do.
I have attached a sample, could anyone help please?
