Add new rows based on cell value within row

Question

I want to split this dataset:

To create new rows equal to the number in the "Number Produced" column. It would be in another table, retaining just Document type and Date.

So for The first row, there would then become 20 rows saying doc type "social housing" and dated in April.

Also, if there's an easier workaround please let me know. I have several datasets in this format with a range of documents, with dates being on a monthly basis, and I have another set which has one row per document with specific timestamps.

Answer 1

Hi @Fergus Spence

I would recommend you post this on the Microsoft Excel Community located at https://techcommunity.microsoft.com/t5/microsoft-excel/ct-p/Excel_Cat -- Power Query is not supported on this forums at this time.

Power Query for Excel Help

https://support.microsoft.com/en-us/office/power-query-for-excel-help-2b433a85-ddfb-420b-9cda-fe0e60b82a94

-----------------------------------

If this is helpful please accept answer.