ESCAAGROVET
New Member
- Joined
- Jan 30, 2021
- Messages
- 10
- Office Version
- 2019
- Platform
- Windows
Arrange Single Row to Multiple Row Based on Criteria
Hi Friends,
I have Product Data in Single Row in following order (data in tabular form at end of sheet)
Above data is required to be sorted in new sheet as following
1. Row number 2,3,4, are for refrence only. Not Required In actual output
2. If Varient 1 or varient 2 Data is blank it needs to be skipped
Your help will be of immense help.
Thanks to all of you in advance for giving precious time of yours.
Hi Friends,
I have Product Data in Single Row in following order (data in tabular form at end of sheet)
Above data is required to be sorted in new sheet as following
1. Row number 2,3,4, are for refrence only. Not Required In actual output
2. If Varient 1 or varient 2 Data is blank it needs to be skipped
Your help will be of immense help.
Thanks to all of you in advance for giving precious time of yours.
# | Unique ID | Variant ID | Item Name | Vendor | Category | Packing | Packing Unit | Weight (gm) | Barcode | Image | HSN | Tax Rate | Varient ID 1 | Packing | Packing Unit 1 | Weight 1 | Varient ID 2 | Packing | Packing Unit 2 | Weight 2 |
1 | 10000 | 10000 | ITEM A | VEND 1 | CATG 1 | Packing | 10Kg | 10000 | 10000 | https://cdn.shopify.com/s/files/1/0270/5499/7569/products/ARAROTLOOSE.jpg?v=1607366547 | 1101 | 00 | 10000 B | Packing | 5Kg | 5000 | 10000 C | Packing | 50Kg | 50000 |
2 | 10001 | 10001 | ITEM B | VEND 2 | CATG 2 | Packing | 100Kg | 100000 | 10001 | https://cdn.shopify.com/s/files/1/0270/5499/7569/products/ARAROTLOOSE.jpg?v=1607366547 | 1102 | 00 | 10001 B | Packing | 15Kg | 15000 | ||||
3 | 10002 | 10002 | ITEM C | VEND 3 | CATG 3 | Packing | 1000Kg | 1000000 | 10002 | https://cdn.shopify.com/s/files/1/0270/5499/7569/products/ARAROTLOOSE.jpg?v=1607366547 | 1103 | 00 | ||||||||
4 | 10003 | 10003 | ITEM D | VEND 4 | CATG 4 | Packing | 10001Kg | 1000100 | 10003 | https://cdn.shopify.com/s/files/1/0270/5499/7569/products/ARAROTLOOSE.jpg?v=1607366548 | 1104 | 00 |