Reporting from several groups

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

All comments

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

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

Merge groups.yxmd

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

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

file_formating.yxzp

Ar13f

Dear @Christina_H and @Ladarthure ,

thank you for your advice ...

pdave87

@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 ...

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703