Arrange (Transpose) Single Row to Multiple Row Based on Criteria

Status
Not open for further replies.

ESCAAGROVET

New Member
Joined
Jan 30, 2021
Messages
10
Office Version
  1. 2019
Platform
  1. 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)

Sample data.png



Above data is required to be sorted in new sheet as following
Sample Output.png


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 IDVariant IDItem NameVendorCategoryPackingPacking UnitWeight (gm)BarcodeImageHSNTax RateVarient ID 1PackingPacking Unit 1Weight 1Varient ID 2PackingPacking Unit 2Weight 2
11000010000ITEM AVEND 1CATG 1Packing10Kg1000010000https://cdn.shopify.com/s/files/1/0270/5499/7569/products/ARAROTLOOSE.jpg?v=160736654711010010000 BPacking5Kg500010000 CPacking50Kg50000
21000110001ITEM BVEND 2CATG 2Packing100Kg10000010001https://cdn.shopify.com/s/files/1/0270/5499/7569/products/ARAROTLOOSE.jpg?v=160736654711020010001 BPacking15Kg15000
31000210002ITEM CVEND 3CATG 3Packing1000Kg100000010002https://cdn.shopify.com/s/files/1/0270/5499/7569/products/ARAROTLOOSE.jpg?v=1607366547110300
41000310003ITEM DVEND 4CATG 4Packing10001Kg100010010003https://cdn.shopify.com/s/files/1/0270/5499/7569/products/ARAROTLOOSE.jpg?v=1607366548110400
 

Excel Facts

Show numbers in thousands?
Use a custom number format of #,##0,K. Each comma after the final 0 will divide the displayed number by another thousand
Status
Not open for further replies.

Forum statistics

Threads
1,223,881
Messages
6,175,159
Members
452,615
Latest member
bogeys2birdies

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top