Help loading in data and applying the correct value to its section

[hopkinsc]

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?

[sunny_talwar · Accepted solution]

How do you like this?

[hopkinsc]

Excellent 🙂 Thanks again.