creating tables total rows

Public Schedule Face-to-Face & Virtual Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Creating tables from total rows

Creating tables from total rows

resolvedResolved · Urgent Priority · Version 365

Rose has attended:
Excel Intermediate course
Excel Advanced course

Creating tables from total rows

Hi there,

Is there anyway to create a pivot table from the total rows of other tables please?

I have 4 tables for each year, each with a total row and want to create a new table from the results of the total row split by each year.

Many thanks,

RE: Creating tables from total rows

Hi Rose,

Thank you for your question to the forum

It may help to send me a sample of the data you are trying to manipulate. Please email:

Kind regards
Martin Sutherland
(IT Trainer)

Will be marked as resolved in 5 days

Notice: This is an automated message. Due to inactivity, this forum post will be marked as 'resolved' if there are no further responses in the next 5 days.


Excel tip:

Paste with Live Preview in Excel 2010

Did you know you can preview what you are about to paste? Here's how to do it.

Copy what you are about to paste
Position the cursor where you want to paste
Right click to display the shortcut menu
Place the cursor over the Paste Options and this will give you a preview of the what you are about to paste.

View all Excel hints and tips

Server loaded in 0.07 secs.