List count


#1

Dear all,
I have a list of elements and their count (refer image 1) . But I need it in the other format of list as image-2. Any solution will be helpful.

List 3

List 4

Thanks in advance,
Ilayaraja P


#2

Like this? It creates a list with the item name and count of occurence.

edit: It requires the Clockwork package for the Node List.SublistLengths


#3

Try List.GroupByKey, where the list is your counts and the key is your headings. May have to use a List.transpose and and then add the headings to the front of your list.


#4

Thanks @Claus and @JacobSmall for your reply.
I have the combined list but I want the list in other format like Image-2.


List 4

Thanks
Ilayaraja P