Merging two single column tables creating a new row for each pair

If you attach a sample file with your current layout and how you want it to appear (well, part of it), then I can give you some formulae to achieve this.

To attach a file, click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post.

Pete

Here is a file

You can put this formula in E2:

=IF(ROWS($1:1)>(COUNTA(A:A)-1)*COUNT(C:C),"",INDEX($A$2:$A$11,INT((ROWS($1:1)-1)/COUNT(C:C))+1))

and this one in F2:

=IF(E2="","",INDEX($C$2:$C$13,MOD(ROWS($1:1)-1,COUNT(C:C))+1))

then copy them down until you get blanks - in this case that will occur after row 121.

Hope this helps.

Pete

You're welcome, Nigel - thanks for the rep.

If that takes care of your original question, please take a moment to select Thread Tools from the menu above your first post and mark this thread as SOLVED.

Pete