If your input data includes the percentage , then it is resulted from this calculation : Original amount X(1+percentage) that is Net amount X (1+R%)
hence the reverse would be Grossup divided by )1+R%
Say in Column A the amount is 100
then in column B you enter =A/(1+7%)
the result would be 93.46
in column C the formulka is B*7%
the result will be 6.54
and column D is B+c
and then you can copy the coloumns and use the paste special and transpose them in the format your are looking for
Hope this help