Join and add columns and data to an existing excel report

[mphillips27]

Hello,

I'm very new to alteryx. 

I am downloading a cvs file with data that I need formatted into an existing excel report. The viewers prefer seeing the data laid out horizontally for multiple months "month over month" -- so the headers look like below

                 | July                            | August                        | Sept

Project ID | Start% | End% | Date | Start% | End% | Date | Start% | End% | Date

The data I download is the latest months Projects Start%, End% and date with the Project ID being the unique id for each. The report has a lot of formatting that needs to be preserved.

Is it possible to append the new data to the report using the project ID to map the data to proper row for the project ID? Ideally I would want it to append the columns of data to the first blank column then map from there.

Thanks!

[danilang]

Hi @mphillips27 

Can you provide some sample input data and a sample of the output report

Dan

[mphillips27]

Sample input and sample output report attached.