Forum Discussion
Merge different Tables
Hi,
you can simply use fill down on a duplicated column then append and filter (see the attached file)
If this post is useful to help you to solve your issue consider giving the post a thumbs up and accepting it as a solution !
No I really need to split in 2 tables, because these 2 tables have different fields. Sorry I did not want to make the explanation of the issue too complex and omited that.
My csv files looked like that:NewCustomers
Name Date ProductCust A xyz abc
Cust B
Cust C
...
BLANK line
LostCustomers
Name Date Reason
Cust D ghj blabla
Hi,
i don't know if i understand well your question.
I think you can also use a unique table (see the new file)
No I really need to split in 2 tables, because these 2 tables have different fields. Sorry I did not want to make the explanation of the issue too complex and omited that.
My csv files looked like that:
NewCustomers
Name Date Product
Cust A xyz abc
Cust B
Cust C
...
BLANK line
LostCustomers
Name Date Reason
Cust D ghj blabla