Getting this data to be usuable

[jakedawson]

Hey guys, This data is pulled from a HTML file that is received from an API call. when it comes in it looks like this

I cant figure out how to get it usable. I want the top row to be a harder column and the rest of the data below to be the rows. However when I import it all comes into one row and column. I tried split by delimiter "," however, that just puts it all in the same row. What can I do?

[Anonymous]

You could probably surround that data with Csv.Document(your data).

--Nate

[wdx223_Daniel]

NewStep=Table.PromoteHeaders(#table(null,List.Transform(Text.Split(PreviousStepName,"#(lf)"),each Text.Split(_,","))))

[jakedawson]

I then get this error

[AlexisOlson · Accepted solution]

Text.Split expects a text value for the first argument, so you need to reference a string rather than a table. One option is to use row and column to pick out a specific table cell to use. For example, #"Converted to Table"{0}[Column1] give the value in the first (index 0) row and column [Column1]. Another option might be to not convert to a table in the first place.