To pull row data into columns

Jithin00 

you can try this.

1. merget columns

="Task1"&"-"&[Task1]&"-"&[Feedback1]&";"&"Task2"&"-"&[Task2]&"-"&[Feedback2]&";"&"Task3"&"-"&[Task3]&"-"&[Feedback3]

2. remove useless columns

3. split column by delimiter to rows

4. split colmn by delimiter again.

let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WckzJLFHSUbLUMwOSFiAWEKfn56cAqbzM5FQglVqRnJqTmleiFKsTrRSckVickZiXDVVtoQdSb2iAUB2WWlSpADUgILUoLTUZqDEWAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Name = _t, Task1 = _t, Task2 = _t, Task3 = _t, Feedback1 = _t, Feedback2 = _t, Feedback3 = _t]),
#"Added Custom" = Table.AddColumn(Source, "Custom", each "Task1"&"-"&[Task1]&"-"&[Feedback1]&";"&"Task2"&"-"&[Task2]&"-"&[Feedback2]&";"&"Task3"&"-"&[Task3]&"-"&[Feedback3]),
#"Removed Columns" = Table.RemoveColumns(#"Added Custom",{"Task1", "Task2", "Task3", "Feedback1", "Feedback2", "Feedback3"}),
#"Split Column by Delimiter" = Table.ExpandListColumn(Table.TransformColumns(#"Removed Columns", {{"Custom", Splitter.SplitTextByDelimiter(";", QuoteStyle.Csv), let itemType = (type nullable text) meta [Serialized.Text = true] in type {itemType}}}), "Custom"),
#"Split Column by Delimiter1" = Table.SplitColumn(#"Split Column by Delimiter", "Custom", Splitter.SplitTextByDelimiter("-", QuoteStyle.Csv), {"Custom.1", "Custom.2", "Custom.3"}),
#"Changed Type" = Table.TransformColumnTypes(#"Split Column by Delimiter1",{{"Name", type text}, {"Custom.1", type text}, {"Custom.2", type number}, {"Custom.3", type text}})
in
#"Changed Type"