I have a large pivot table with the following data. The bold text is the parent row of data and the following years (non-bold data) are the child data of the parent row. Is it possible in excel or python with a formula to concat all the child row data into a one row in the following column next to the parent row. I want to be able to make the dataset look like the following.