Laurens19995
New Member
- Joined
- Apr 12, 2021
- Messages
- 9
- Office Version
- 365
- Platform
- Windows
Hi everyone,
I already did a lot of research on finding a correct macro or other way to transfer data from horizontal to vertical, whilst in some columns I want to have the same records. And the records should stay the same until the whole row is converted to vertical. And I would also like to skip the empty cells.
Example:
Then I would like to have in converted like this:
So basically column A-C should be repeated until all data in the column codes has been filled from the same order number. And the number of pallets, parcels and kg's repeated once.
Hopefully this is possible!
Many thanks for your support already!
I already did a lot of research on finding a correct macro or other way to transfer data from horizontal to vertical, whilst in some columns I want to have the same records. And the records should stay the same until the whole row is converted to vertical. And I would also like to skip the empty cells.
Example:
Ordernumber | LOADING | UNLOADING | Pallets | Parcels | Kg's | Code transport | Cost transport | Code fuel | Cost fuel | Code time delivery | Time delivery costs | Additional code costs | Additional costs | Extra cost code | Extra costs |
61053744 | Amazon | Walmart | 1 | 0 | 1826,634 | FR1 | € 100,00 | FR3 | € 41,65 | FR5 | € 50,00 | AA100 | € 75,00 | AA101 | € 10,00 |
61054012 | Amazon | Tiffany | 3 | 0 | 515,52 | FR19 | € 100,00 | FR20 | € 38,83 | AA102 | € 75,50 | ||||
61053947 | Amazon | Walmart | 0 | 3 | 458,832 | FR2 | € 100,00 | FR3 | € 38,58 | AA104 | € 50,00 | AA105 | € 75,50 | AA106 | € 10,00 |
Then I would like to have in converted like this:
Ordernumber | LOADING | UNLOADING | Pallets | Parcels | Kg's | Code | Costs |
61053744 | Amazon | Walmart | 1 | 1826,634 | FR1 | $ 100,00 | |
61053744 | Amazon | Walmart | FR3 | $ 41,65 | |||
61053744 | Amazon | Walmart | FR5 | $ 50,00 | |||
61053744 | Amazon | Walmart | AA100 | $ 75,00 | |||
61053744 | Amazon | Walmart | AA101 | $ 10,00 | |||
61054012 | Amazon | Tiffany | 3 | 515,52 | FR19 | $ 100,00 | |
61054012 | Amazon | Tiffany | FR20 | $ 38,83 | |||
61054012 | Amazon | Tiffany | AA102 | $ 75,50 | |||
61053947 | Amazon | Walmart | 3 | 458,832 | FR2 | $ 100,00 | |
61053947 | Amazon | Walmart | FR3 | $ 38,58 | |||
61053947 | Amazon | Walmart | AA104 | $ 50,00 | |||
61053947 | Amazon | Walmart | AA105 | $ 75,50 | |||
61053947 | Amazon | Walmart | AA106 | $ 10,00 |
So basically column A-C should be repeated until all data in the column codes has been filled from the same order number. And the number of pallets, parcels and kg's repeated once.
Hopefully this is possible!
Many thanks for your support already!