Forum Discussion
Solved
Multiple fields reduced Excel
I am pretty new to Excel so probably finding the easy stuff had, but I'm wondering if anyone can help me with this. My data set has come from a .txt file, and I'm trying to turn it into usable data i...
Here's my very similar PQ approach to Herbert_Seidenberg I named the range of cells first rather than converting it to a table
If this layout is an extract from a system then use Power Query to reference that text file without even opening it
If you're not familiar with Power Query then check out my intro video here...
https://youtu.be/QkvCkU5QB4c