I was hoping if any of you would be able to help me. I am trying to create a dendrogram that resembles the one here: http://bl.ocks.org/mbostock/4063570. However, the data from my spreadsheet end at differing columns, so those that end at lower columns lead to empty nodes extending from them until they catch up to those of the last column. I know that moving the data of the lower columns to the last column will make the dendrogram look like the example that I want (the right side). However, the columns preceding them will lead to empty nodes. Is there anything I can input in the empty cells to make the lines elongate and not create a node, like in the example?
Any help is greatly appreciated.
Kind regards,
Long