Excel format issue

Hi guys thanks for the replies, I have realised that the way I presented the question wasn't quite as I intended, the attached file shows it a bit clearer, hopefully it makes sense and again it is from the top table to the bottom one.Excel test v2.xlsx