How to convert text string to datatable variable

In the Sheet 1 there is data @vickydas.
My requirement is to get in this way ,

But now am getting in this way,

This is because of the excel formatting. Increase the column width for all the cells. It will look like the earlier one.
Do Ctrl+A and click on wrap text option on the action bar

1 Like

Use Generate data table and pass the string value

project.json (1.5 KB)
String to Datatable.xaml (8.1 KB)