Looking for help
A B C D E F 1 Food Petrol Rent Wages 2 **Food** 12 3 **Petrol** 35 4 **Rent** 120 5 **Wages** 300
I have a formula that copies values into cells C2:F5 -onwards but I'm having difficulty coming up with a formula that copies the column header "Food/Petrol/Rent" into the B column if there is a value in the appropriate cell in the column
So if C2 has a value then B2=C1
If F5 has a value then B5= "Wages"
currently I have 38 Columns and nearly 1000 Rows, it could get complicated to do it all manualy
Thanks in advance