Hi,

I was trying to develop a macro in the attached sheet that would take information from the data sheet, guided by the columns indicated in the Inputs sheet.

Table to Row.xlsm

In the example I gave an example of how I want the data to be populated.

The complicated part is that depending on the number of business processes there are it can make the impacts and revenue very large and thus needing a way to figure out which of the rows is for which business process.

So on the processs information I specified which were needed to be populated by the macro and I show on the ideal layout what it should look like.

Thanks!