repeating rows

I have two PivotTable fields in the row section, seen below, I need the Trading Partner field to repeat next to the Transaction Set field on the entire pivot table. Below is also an example of what I am looking for. Is there a way to do this automatically so I do not have to do this by hand...

Its been a long time since I've worked deeply in Excel. (Im using Excel for Mac 2011, FYI). In this case I'm dealing with exported data in a table. My example is a gross simplification, to get to the basic question. Assuming I have data like below, that is sorted and repeats, I'd like to...

I am trying to pivot columns with repeating data to rows. However as I have duplicated information in the Data column when I Pivot (Don't aggregate) I get the following error message. <tbody> <tbody> Value Data Name Eric Address Line 1 29 Acacia Road Address Line 2 Dandytown Address...

<colgroup><col><col></colgroup><tbody> I have imported a txt file in to Query editor, separated in to two columns and cleansed the data to give me a data set with 31 unique row labels in column A and the information in column B. (see below) Is there a way I can transform this data within query...

Hello there. I have my sheet set up horizontally, containing data from A1 to BR46 (almost 7 pages). I have some data in A1:H3 that I want to repeat at every page's top. I also have a column that I want on every page. I tried "Rows to repeat at top" and "Column to repeat at left". The Column...