Reconstruction
Posted: June 21st, 2023, 11:37 pm
Hi everyone,
I'm seeking suggestions on how to perform batch editing to reconstruct this record:
The column size is fixed, but the row size depends on the number of sellers.
If you have any ideas or recommendations, please share. Thanks
Record Seller
seller Item_1 Item_2 Item_3 Item_4
1 mark apple amla annona avocado
2 john banana buns basket bars
3 karen egg eel wax shoe
4 joe lace paper shirt wire
Into
Record seller
item seller
1 apple mark
2 amla mark
3 annona mark
4 avocado mark
5 banana john
.
.
.
20 wire joe
I'm seeking suggestions on how to perform batch editing to reconstruct this record:
The column size is fixed, but the row size depends on the number of sellers.
If you have any ideas or recommendations, please share. Thanks
Record Seller
seller Item_1 Item_2 Item_3 Item_4
1 mark apple amla annona avocado
2 john banana buns basket bars
3 karen egg eel wax shoe
4 joe lace paper shirt wire
Into
Record seller
item seller
1 apple mark
2 amla mark
3 annona mark
4 avocado mark
5 banana john
.
.
.
20 wire joe