Forum Discussion

dkingsbury's avatar
dkingsbury
Copper Contributor
Apr 26, 2022

Create a list from an existing list in excel

I have a table with non-numerical values that are being populated from an if/index formula. For example, I have the following set of data:   Hello This   is This     my ...
excel
Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
Apr 26, 2022

dkingsbury You may want to look into PowerQuery to achieve this, as demonstrated in the attached file.

Alternatively, as in Insider (beta channel) you can use this:

 

 

=TOCOL(Table1,1,TRUE)

 

Edit: Added another, even simpler PQ solution.

Resources