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

[ESCAAGROVET]

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.

#

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

 

[Fluff]

Duplicate to: Sorting Single Row to Multiple Row Based on Criteria

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.