Forum Discussion

mcunliffe's avatar
mcunliffe
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's avatar
    mcunliffe
    Nov 01, 2021

    Hi PeterBartholomew1 

     

    Thanks for your reply. I keep getting #NAME? 

    Where am I going wrong with this?

     

PeterBartholomew1's avatar
PeterBartholomew1
Silver Contributor
Nov 01, 2021

Wyn Hopkins 

Thanks, I probably should put more effort into describing the defined Names; just because I haven't used a direct cell reference since 2015 certainly doesn't mean others are familiar with the approach. In this instance, I was unsure whether it is 'Source' that is the problem or my use of the 365 functions LET and SEQUENCE.
I am an infrequent user of the Power tools so I still find it somewhat difficult to visualise the result of pivoting and unpivot steps. I presume it becomes easier with practice.

Resources