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

Status
Not open for further replies.
E

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

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.
Sort by date Sort by votes
Status
Not open for further replies.

Similar threads

E
  • Question Question
Arrange (Transpose) Single Row to Multiple Row Based on Criteria
Replies
2
Views
570
ESCAAGROVET
E
S
  • Question Question
Deleting multiple rows, columns, unmerging, pivot table all at once.
Replies
2
Views
102
HighAndWilder
H
F
  • Solved
Transpose single column into multiple rows based on criteria
Replies
2
Views
663
farisi
F
K
  • Question Question
Convert single row data into multiple lines based on Qty
Replies
2
Views
319
key3535
K
M
  • Solved
Transposing multiple columns to rows based on unique values from first column
Replies
4
Views
1K
mattc1985
M

Forum statistics

Threads
1,224,816
Messages
6,181,139
Members
453,021
Latest member
Justyna P

Share this page

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