Beachball21
New Member
- Joined
- Feb 2, 2021
- Messages
- 6
- Office Version
- 2016
- Platform
- MacOS
Hi,
I have a file that has order data/rows and I am trying to break out and create new rows in it automatically based on a cell value in the memo column. For example,
In the the screenshot below (apologies for the screen shot as I am on mac and can't configure xl2bb as it is incompatible with my machine), I am trying to breakout row 2 and create new lines in the same sheet because the memo field has a specific value i.e. J-INT0000****. Withe new rows, the goal is to create them with the same value for all the other columns as it is in row 2, the only difference is that the memoe field will now old a single -INT value.
In this case this will result in 4 new rows created for this order (column d). Then rinse and repeat in the entire sheet for each unique order.
Is this possible in excel or will i have to use some other form of scripting to get this done?
I have a file that has order data/rows and I am trying to break out and create new rows in it automatically based on a cell value in the memo column. For example,
In the the screenshot below (apologies for the screen shot as I am on mac and can't configure xl2bb as it is incompatible with my machine), I am trying to breakout row 2 and create new lines in the same sheet because the memo field has a specific value i.e. J-INT0000****. Withe new rows, the goal is to create them with the same value for all the other columns as it is in row 2, the only difference is that the memoe field will now old a single -INT value.
In this case this will result in 4 new rows created for this order (column d). Then rinse and repeat in the entire sheet for each unique order.
Is this possible in excel or will i have to use some other form of scripting to get this done?