Excel Flatten function not working and not existing

[Jungwoo_Kim]

Hi,

I'm trying to user Flatten Function and it seems like it doesn't exist.

And it is showing as #NAME?. I wonder what is issue.

my Excel versions is students version.

is there anyone can help me?

Thank you.

[#2]

FLATTEN is not excel function. It is google sheet function. Use TOCOL() function in Excel.

[#3]

@Harun24HR  wrote:  ``Use TOCOL() function in Excel. ``

But beware:  according to the TOCOL help page (click here}:

:(

(Office Insider Beta only)
Windows: 2203 (Build 15104)
Mac: 16.60 (220304)

[#4]

Microsoft releases all new formulas fully to Excel for web as well as Current Channel (Not only BETA Channel).