Excel format issue

Hi Tony,

Not sure if its the easiest way but you could create a transpose array formula for each column. Check out the formula in cells A30 and A31. To enter an array formula you need to enter it using ctr+shift+return. My own knowledge would limit me to having to creat a seperate formula for each column as the formla does not increment correctly when copied.