Hi all I have a list like List8abc2021.01.01 13:45:00011010 How can I convert this list to a table? Is there a function or do I need to do it manually? Should look something likeValuetexttimebit8abc2021.01.01 13:45:00011010 Since the source is a list, transforming options like pivot, unpivot are not available.Trying to convert the list in a table "to table" results in errors, since each row is another type. best aleks

Fount the solution When converting "to table" you have to choose as a delimiter "none". After that it is possible to transpose the table.

Forum Discussion

Anonymous

Not applicable

5 years ago

Solved

Hi all

I have a list like

List

abc

2021.01.01 13:45:00

011010

How can I convert this list to a table? Is there a function or do I need to do it manually?

Should look something like

Value	text	time	bit
8	abc	2021.01.01 13:45:00	011010

Since the source is a list, transforming options like pivot, unpivot are not available.

Trying to convert the list in a table "to table" results in errors, since each row is another type.

best

aleks