G
Guest
I have a few lists: (columns and rows)
List1 List2 List3
apple red 10 apple red 30 apple blue 30
apple red 10 orange red 30
apple blue 20 apple blue 30
orange red 20 banana 10
These list are updated periodically, either adding more data or erasing
them. I'd like to combine them into a single list data so that i can sort
them according to the "fruit" and "color", then add up the subtotal in each
change in "color".
The problem is i have about >80 lists, to copy and paste them one by one is
time consuming.
Is there a simple way to copy and paste these lists in the desired order for
sorting and subtotal?
List1 List2 List3
apple red 10 apple red 30 apple blue 30
apple red 10 orange red 30
apple blue 20 apple blue 30
orange red 20 banana 10
These list are updated periodically, either adding more data or erasing
them. I'd like to combine them into a single list data so that i can sort
them according to the "fruit" and "color", then add up the subtotal in each
change in "color".
The problem is i have about >80 lists, to copy and paste them one by one is
time consuming.
Is there a simple way to copy and paste these lists in the desired order for
sorting and subtotal?