Redistribute rows based on cell value

RobV1989

New Member
Joined
Sep 5, 2014
Messages
11
Hi all,

I'm stuck on the following. I have a dataset which includes, amongst others, a date column, customer and number of pallets delivered. However, I would like to redistribute rows based on the value in pallets delivered column (column K); if this value is higher than 26, these specific rows should be redistributed into new rows, where the values in all other columns remain the same, except for column K. For example; cell K2 contains '59', new rows K3, K4 and K5 should state 26, 26, 7 respectively.

I am not even sure if this a realistic option. If you have other suggestions, please let me know.


Thanks in advance,
Rob

ps. I'm not a VBA expert, but I know how to implement codes.
 

Some videos you may like

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.

Watch MrExcel Video

Forum statistics

Threads
1,108,609
Messages
5,523,883
Members
409,541
Latest member
pgiering

This Week's Hot Topics

Top