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...
better if you share Excel file with exactly same information as on screenshot, it will be easier to illustrate the proposed solution.
Thanks SergeiBaklan I've attached the Excel file.
This is very easy for an Excel 365 user but a little messier using traditional techniques.
= LET( k,SEQUENCE(4,5), INDEX(source,k))
