How to keep duplicate data to new table?

[Anonymous]

Hi all,

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?

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

[Fowmy · Accepted solution]

@Anonymous 

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

[Anonymous]

Thank you!