Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
MichaelHutchens
Helper IV
Helper IV

Moving multiple rows in a table to a single line

Hi folks, I'm hoping someone might be able to help. I have a table of survey results, with 4 questions per reference number. The questions are on separate rows and I need to move them to a single line, one for each reference number.

Here's my sample data:

Ref numberAssignment groupAssigned toQuestionResult
12345Service Team

Jimmy Jimso

 

n

On a scale of 0-10 (10 being incredibly satisfied) how satisfied were you with your most recent support experience?10.00
12345Service TeamJimmy JimsonWhy did you score us that way?text goes here
12345Service TeamJimmy JimsonPlease contact me to discuss this incident/request furtheryes please
12345Service TeamJimmy JimsonWhat was the one thing that we could do to improve this score?text goes here
789120Service Team 2Sarah SarahsonOn a scale of 0-10 (10 being incredibly satisfied) how satisfied were you with your most recent support experience?9.00
789120Service Team 2Sarah SarahsonWhat was the one thing that we could do to improve this score?text goes here
789120Service Team 2Sarah SarahsonPlease contact me to discuss this incident/request furthertext goes here
789120Service Team 2Sarah SarahsonWhy did you score us that way?text goes here
567890Service Team 2Peter PetersonOn a scale of 0-10 (10 being incredibly satisfied) how satisfied were you with your most recent support experience?10.00
567890Service Team 2Peter PetersonWhat was the one thing that we could do to improve this score?text goes here
567890Service Team 2Peter PetersonPlease contact me to discuss this incident/request furthertext goes here
567890Service Team 2Peter PetersonWhy did you score us that way?great service!

 

And here are my expected results:

Ref numberAssignment groupAssigned toOn a scale of 0-10 (10 being incredibly satisfied) how satisfied were you with your most recent support experience?Why did you score us that way?Please contact me to discuss this incident/request furtherWhat was the one thing that we could do to improve this score?
12345Service TeamJimmy Jimson10.00text goes hereyes pleasetext goes here
789120Service Team 2Sarah Sarahson9.00text goes heretext goes heretext goes here
567890Service Team 2Peter Peterson10.00great service!text goes heretext goes here

 

I'd really appreciate any help you can provide 🙂

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

2 REPLIES 2
amitchandak
Super User
Super User

That worked @amitchandak , thanks! 🙂

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.