Home

Query Trouble

Highlighted
Steph_tucker
Occasional Contributor

So - I imported Files into a query using the data from folder option. The files all have the same header so that the team knows what they are entering into the spreadsheet. I just want the header on the query but it shows every couple of lines for each different file. After I format the query (after closing and loading) once I refresh it after changing data in a file the format goes back to the original pre-formatting. How do I get my query to keep the format even after I hit refresh? I have attached the file for a reference. 

Related Conversations
Sorting problem with imported data from query
DenisL in Excel on
5 Replies
Query Design
Siriah in Access on
1 Replies
Power Query freezes in Excel
ire123 in Excel on
0 Replies