datamash | Send questions

I am using Datamash 1.7 on Centos 7.7 Linux x86_64 machine to sort and bin data which is 24 GB in size. Input data looks as follows (only first 50 samples)

I have a large text file with 100000 rows and columns as like this

NEED: I have a file containing data like the sample below. I need to:

1. Merge all lines into one line when X number of fields match
2. Create range of values in X number of fields when the values vary

In this case: Merge all lines into one where fields $1 through $6 and $8 match, create a range of the associated values in field $7

OR

Merge all lines into one where fields $1 through $7 match, create a range of the associated values in field $8*

1. The solution has to be something native to Linux (like a bash or awk script) that doesn't require installation of additional software (e.g. datamash).

@rtx13's solution below using TCL does work (thanks again), I'm just not sure if I can install TCL in my live environment so I hope and AWK/BASH/etc. solution can also be proposed.

Original data:

I need to produce a sliding window of millions of lines and to calculate the median of column 3. My data looks like this with column 1 always being the same, column 2 equaling the line number and column 3 being the information that I need the median for:

Im trying to "convert" the following file from multiple rows into separated column.

classr#94 mesur#237 high#228 cash#232
classr#118 mesur#332 high#430 cash#421 Sar#380 classr#57 mesur#89 hight#65

My desired output:

classr#94
mesur#237
high#228
cash#232
classr#118
mesur#332
high#430
cash#421
Sar#380 classr#57
mesur#89
hight#65

I tried datamash -t: transpose < Filename but converted my file in very "weird" way

I also tried grep -o # File_name but i got only the #.

I think in the grep case if I find the way to get the entire word I will obtain the desired output.

I have a directed graph with like 2000 nodes stored in a file. Each line represents an edge from the node stored in the first column to the node stored in the second column, it is even easy to visualize the data for example in dot(1). Columns are separated by tabs, rows separated by newlines and nodes are named with any of the a-zA-Z0-9_ characters. Tree can have multiple roots, it may have cycles, which should be ignored. I don't care about cycles, they are redundant, but they can happen in the input. Below I am presenting an example of the graph, with tr to substitute spaces for tabs and here-document, to easy reproduce the input file:

Consider the following:

I have tried several awk and sed commands and GNU datamash to change the format and code the missing fields as "??" of this data file with no success. I have a file with a format that looks like the following:

I have a system command which i am trying to execute, but it gives me error "Syntax error: redirection unexpected"

Trying command: