Forum Discussion
How to expand table data in elaborated table (as shown in the attachment)
Hi Every one Happy Chrismas and New Year in Advance How to expand the table (Table A) based on no of sold and item. It should be shown in the same sequence in one column (Table B) itself?
Hi,
Actually I want to list out unit price in the number mentioned in the no of sold.
For Eg:
Glassi Sold 8 Times. So i want to list out glassi price 8 times in the same column.
Just to be clear: List.Numbers is a function within Power Query.
So you have to load the table into Power Query and add a custom column with containing this function.
See attached file.