Hi, I am trying to write a macro to rearrange data in one spreadsheet into the format of another (see JPEG attached). This involves creating a row for each value in the top table so it is presented in the format in the bottom table. Please help as I haven't got a clue how to do this.