Need to seperate multiple data from one column to multiple column

ShashankSaxena-2458 131 Reputation points
2022-11-18T17:06:11.543+00:00

Hello All,

I hope all are doing good.

I am trying to separate the data from Power Query which is mentioned in the Input Table, but I am not getting the desired data which is mentioned is mentioned in Output Table . Can anyone please help me to get this data sorted.

Regards,
Shashank Saxena

261968-image.png
262021-image.png

Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,488 questions
Office Mac
Office Mac
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Mac: A family of Apple personal computers that run the macOS operating system.
457 questions
Office Management
Office Management
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Management: The act or process of organizing, handling, directing or controlling something.
2,000 questions
Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,640 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Herbert Seidenberg 1,191 Reputation points
    2022-11-18T19:32:53.767+00:00