Split table record into multiple records/rows in a new table

[gangu]

Hey Guys,
In a situation where I imported an excel file with so many columns and split them into two temp tables and they are linked using a key.

the data has a fixed part lets say

Field1....Field2.....Filed3.....Field4...then Field5.....Field6.....Field7....Field8 is the same data range as Field9...Field10...Field11...Field12. I would want to split this data into multiple rows like this

Field 1 Field2 Field3 Field4 Field5 Field6 Field7 Field8
Field 1 Field2 Field3 Field4 Field9 field10 field11 field12 and so own, please what is the best approach?
Your help is greatly appraciated

 

[JHB]

Try if an Union query can save your problem, below is a link to a description with some sample.
https://support.office.com/en-us/ar...on-query-3d4fd525-e5ac-4245-99b3-4f4b66cdb2a1

 

[gangu]

Thanks mate.....in my case the repeatitive pattern of fields/data is about 25 times, and note I want to insert these in a new table can the union bit work on these? Sorry might sound naive but still a newby

 

[JHB]

First create the union query, then create a Make table query based on the union query.