Moving Titles

[Vegas01]

Hi everyone

I was wondering how do I get the the title (hightlighted in bold) to join with the Total (in red) in the each section of data or at least putting the heading on the same line with the total?

In the CSV file we receive, it groups type of data together, what I need it the total amounts, for invoicing purposes. (I had a thought of something like everytime you have a blank line do this???)

I hope I have explained it well enough.

Thanks in advance.

__Packed Patient Days__
Ward	Bulk Order Days	@	Total	CD Bulk Order Days	@	Total	CD Mixed Bulk Order Days	@	Total
A1	889	0.01	8.89	0	0.01	0	0	0.01	0
A2	455	0.01	4.55	0	0.01	0	0	0.01	0
A3	630	0.01	6.30	28	0.01	0.28	0	0.01	0
A4	532	0.01	5.32	0	0.01	0	0	0.01	0
A5	21	0.01	0.21	0	0.01	0	0	0.01	0
Total	2527		25.27	28		0.28	0		0
__Courier Fees__
Date	Cost
Total	0
__Fractional Tablets__
FractionsWithoutAlternative	FractionsWithoutAlternativeFee	FractionsWithAlternative	FractionsWithAlternativeFee
1616	0.01	0	0.01
__Chart Care__
	Signing Sheets	Pages	Summary Sheets	Pages	NRMC Sheets	NRMC Pages	Fee	NRMC Fee	Total
Aged Care by MPS	0	0	0	0	0	0	0.10	0	0
Community by MPS	0	0	0	0	0	0	0.10	0	0
Aged Care in Pharmacy	0	0	1	4	0	0	0.10	0	0.2
Community in Pharmacy	0	0	0	0	0	0	0.10	0	0
Totals	0	0	1	4	0	0			0.2

 

[JGordon11]

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    tcn = Table.ColumnNames(Source),
    lst = Table.Column(Source,tcn{0}),
    lst1 = List.Accumulate({0..List.Count(lst)-1}, {}, (s,c)=> let lc = lst{c} in s & 
                {(
                    if Text.Start(Text.From(lc),5) <> "Total" then 
                        lc 
                    else 
                        lc & " " & List.Select(List.Reverse(s), each Text.Start(_,1) = "_"){0}
                )}
            ),
    tbl = Table.FromColumns({lst1} & List.Skip(Table.ToColumns(Source),1), tcn)
in
    tbl

 

[Vegas01]

Ok thanks for the JGordon11, I will give that a go in the next couple of days