Add column based on row

[helpme]

Hi,

I want to add a column based on row 1 below:

so that I end up with a table with the following headers:

Local name	Person ID	Gender	Age	Postcode
Test 1	EXAMPLE001	Female	76	XX00 0XX
Test 1	...	...	...	...
Test 1	...	...	...	...

How do I do this?

Thanks

[AmiraBedh]

Can you please elaborate more the logic behind adding this row ?

[helpme]

The situation is that I am setting up an system where files will be uploaded to a folder monthly. The files will come from different companies.

I will then have to combine the files in order to create a report, therefore i need to know which company the file is coming from.

[AmiraBedh]

Try to give for each file the name of the company (providing the data), and using the combine feature you will have a column with the name of the company (coming from the filename) will be added.

[helpme]

The issue with using the file name or Source.name is that it will vary each month and not necessarily give the name of the company

[AmiraBedh]

Can you give an example of two or 3 files so I can understand the logic behin?