Forum Discussion
How to divide cell value in many lines?
Hello, I would like to create a macro to divide cell value in many lines as the following: Input: A 360 B 120 C 240 D 480 E 60 Output: A 120 A 120 A 1...
Another possible solution with Power Query. In the attached file you can add data to the large blue dynamic table and a divisor in the small blue dynamic table. Then you can click in any cell of the green table and right-click with the mouse and select refresh to update the green result table.