Skip to main content
Support is Offline
Today is our off day. We are taking some rest and will come back stronger tomorrow
Official support hours
Monday To Friday
From 09:00 To 17:30
  Saturday, 25 February 2023
  0 Replies
  2K Visits
0
Votes
Undo
hi,

How can I reorder the following data? depending on the columns. and Delete the lines that do not have data.

LOCAL SKU LOTE VENDOR1 VENDOR2 VENDOR3
1 145B QW8 20 30 50
2 256E RD95 25 [/color] 5
3 356Y GH23 63 10 30

desired result


LOCAL SKU LOTE Cant
1 145B QW8 20 VENDOR1
2 256E RD95 25 VENDOR1
3 356Y GH23 63 VENDOR1
1 145B QW8 30 VENDOR2
3 356Y GH23 10 VENDOR2
1 145B QW8 50 VENDOR3
2 256E RD95 5 VENDOR3
3 356Y GH23 30 VENDOR3
There are no replies made for this post yet.