Reporting from several groups

[Ar13f]

Dear All Members,

I have data taken from a web server, in the report there are several groups of reports as below:

I want to combine the data into a single report as below:

Please find the attached sample report. Really appreciate the advice and help from all of you. 

[pdave87]

@Ar13f Hi, couple of questions:

1. Are input sources different or comes in one excel file?

2. Can you share schema for better understanding? I see names appear in different columns but currency info is inconsistent in schema structure.

Regards,

Pratik

[Christina_H · Accepted solution]

Here's my take, assuming input is in a single file

[Ar13f]

Dear @pdave87 ,

The Answer :

1. in one excel file (in one sheet)

2. actually I just want to move the title of each report into the "source" column

[Ladarthure · Accepted solution]

Here is a solutiuon to do it, it does not includes the renaming of the fields

[Ar13f]

Dear @Christina_H and @Ladarthure ,

thank you for your advice ...

[pdave87 · Accepted solution]

@Ar13f  solution is already provided however, just sharing a trick to move source automatically based on what is updated in input column. Happy solving 🙂

[Ar13f]

Dear @pdave87 ,

thank for your solution too ...