create macro that merges cells and then transposes them into other worksheet

[jloyzaga]

Hi,
new to the forum. I'm an automation tester and am using excel as the data/keyword and script repository. I have keywords and their parameters in sheet 1. this sheet has each row to represent a keyword and its parameters. I am trying to make it more useable. To this end I want to have another sheet that will contain the scripts to run. Each script is represented by many keywords and will be executed from cell 1 to cell9999 by descending row.

What do I need?
I need a macro to go through each row in sheet 1, merge the cells per row so that for example row8 when merged will be (each column to be separated by "|") and look like this in row2 in sheet3 e.g "google_search|Auburn NSW|Maps|www.google.com"
Row1 will contain "$contine_on_error=off" and all cells prefixed with # will be ignored.

This means that the macro will also need to transpose the merged cells into sheet3 .....

Can anyone help?
the spreadsheet is attached