Forum Discussion

Copper Contributor

Oct 29, 2021

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...

excel

mcunliffe
Nov 01, 2021
Hi PeterBartholomew1

Thanks for your reply. I keep getting #NAME?
Where am I going wrong with this?

SergeiBaklan

Diamond Contributor

Oct 29, 2021

mcunliffe

better if you share Excel file with exactly same information as on screenshot, it will be easier to illustrate the proposed solution.

mcunliffe

Copper Contributor

Nov 01, 2021

Thanks SergeiBaklan I've attached the Excel file.

Example.xlsx10 KB

PeterBartholomew1
Silver Contributor
Nov 01, 2021
mcunliffe
This is very easy for an Excel 365 user but a little messier using traditional techniques.
= LET( k,SEQUENCE(4,5), INDEX(source,k))
Example (11).xlsx10 KB
- mcunliffe
  Copper Contributor
  Nov 01, 2021
  Hi PeterBartholomew1
  
  Thanks for your reply. I keep getting #NAME?
  Where am I going wrong with this?
  - Wyn Hopkins
    MVP
    Nov 01, 2021
    You'll need highlight the data in row 2 and use the Name box to name it as SOURCE (at least I'm assuming that's what Peter did