Add rows in between

Hi all. I am looking for a function to add rows in between my existing file.
The table consists of several columns and rows. In column A and column B there are indicators in order to group the data. The rows should then be added in between the different groups and state the name of this group.
Is there any function that could help me?

Hi @Steffi01

Welcome to the forum. An option may be to use a GroupBy to create totals (or mean or count or…whatever) for the columns. Keep the original names in for your calculated columns. I added a column just for sorting purposes. Then concat both streams and do a sort.

forum_20190604.knwf (23.3 KB)

Hope this helps.

gr
Hans

2 Likes

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.