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?

mcunliffe

Copper Contributor

Nov 01, 2021

Hi PeterBartholomew1

Thanks for your reply. I keep getting #NAME?

Where am I going wrong with this?

SergeiBaklan

Diamond Contributor

Nov 01, 2021

mcunliffe

If with legacy formulae, here

in A16

=INDEX($A$2:$T$6, INT( (ROW() - ROW($A$16) -1)/4)+1, 5*MOD( ROW() - ROW($A$16) -1, 4)+COLUMN() - COLUMN($A$16)+1 )

drag it to the right and when entire line down till zero values appear.