What Is the Best Way to Fix a Table with Repeating

Multiple Choice

What is the best way to fix a table with repeating groups?

A) Either fix the repeating groups in Excel before importing to Access or alternately add rows in Access and separate repeating data into individual rows
B) Export table to Excel,fix repeating groups,then import back to Access
C) Create additional columns for repeating data
D) Filter or query the table searching for repeating groups