'Flatten' values in table to individual lines for Pivot Table purposes

[excelhippo]

Hi there,

This is my first post here - hoping that someone can shed some light on this for me!

I have a table that has a feedback question, question rating, and number of respondents that provided that rating - see below:

Feedback Question	Rating	Number of Respondents
Did the course meet your expectations?	4	3
Would you recommend this course to others?	5	2

<tbody>
</tbody>

What I want to do is automatically ungroup the number of respondents, so that there are 3 lines of a rating of 4 for the first question, and 2 lines of a rating of 5, so that I can work with this data in a pivot table easily. Example below:

Feedback Question	Rating
Did the course meet your expectations?	4
Did the course meet your expectations?	4
Did the course meet your expectations?	4
Would you recommend this course to others?	5
Would you recommend this course to others?	5

<tbody>
</tbody>

I'm familiar with ALT+D+P using multiple consolidation ranges to break out data from a crosstab table, but it doesn't seem to help the issue that I'm having here. I ended up having to manually insert lines to create a dataset that was right for a pivot table and I would rather not do it again if possible. I have searched online but I don't think I'm using the right terminology since everything I google brings me back to ALT+D+P and multiple consolidation ranges.

Any advice on how to automate this process would be greatly appreciated!