How to keep duplicate data to new table?

Question

Hi all,&nbsp;I've got a query data with duplicate values and I want to start to create new table with same column of query.How do I keep and copy same column in a new table?&nbsp;For example, there is a query like below and I want to make new table start with column of "Module ID" keeping all duplicate values.Site NameSMP StatusModule IDAYet_To_Start1CYet_To_Start3CYet_To_Start3FYet_To_Start7FYet_To_Start7BYet_To_Start2BYet_To_Start2WYet_To_Start6WYet_To_Start6QYet_To_Start9QYet_To_Start9DYet_To_Start8DYet_To_Start8

fowmy · Accepted Answer

Anonymous&nbsp;I created an additional query which will be dynamically updated as new data get uploaded. File attached below.

&nbsp;

Forum Discussion

How to keep duplicate data to new table?

2 Replies

Related content

Duplicate Table best approach

Duplicate ranking

Table Name Duplicate Error

Create table to remove duplicates

Highlight duplicate values in a table

Site Name	SMP Status	Module ID
A	Yet_To_Start	1
C	Yet_To_Start	3
C	Yet_To_Start	3
F	Yet_To_Start	7
F	Yet_To_Start	7
B	Yet_To_Start	2
B	Yet_To_Start	2
W	Yet_To_Start	6
W	Yet_To_Start	6
Q	Yet_To_Start	9
Q	Yet_To_Start	9
D	Yet_To_Start	8
D	Yet_To_Start	8